星空网 > 软件开发 > ASP.net

csharp: MySQL Stored Procedure using DAL

# 建表 塗聚文 20160907drop table attendrecord;create table attendrecord(  seq INT NOT NULL PRIMARY KEY AUTO_INCREMENT,  emp_no varchar(20) null,  rdate datetime not null,  rtime time not null,  rdescription varchar(100),  rdes_reasnon varchar(100),  branch varchar(50));#存储过程# 添加DELIMITER $$DROP PROCEDURE IF EXISTS `attend`.`proc_Insert_Attendrecord` $$CREATE PROCEDURE `attend`.`proc_Insert_Attendrecord`(	IN param1emp_no VarChar(20),	IN param1rdate Datetime ,	IN param1rtime Time,	IN param1rdescription VarChar(100),	IN param1rdes_reasnon VarChar(100),	IN param1branch VarChar(50))BEGININSERT INTO attendrecord(	emp_no ,	rdate ,	rtime ,	rdescription ,	rdes_reasnon ,	branch)	VALUES(	param1emp_no ,	param1rdate ,	param1rtime ,	param1rdescription ,	param1rdes_reasnon ,	param1branch); END $$DELIMITER ;-- 添加DELIMITER $$DROP PROCEDURE IF EXISTS proc_Insert_Attendrecord $$CREATE PROCEDURE proc_Insert_Attendrecord(	IN param1emp_no VarChar(20),	IN param1rdate Datetime ,	IN param1rtime Time,	IN param1rdescription VarChar(100),	IN param1rdes_reasnon VarChar(100),	IN param1branch VarChar(50))BEGININSERT INTO attendrecord(	emp_no ,	rdate ,	rtime ,	rdescription ,	rdes_reasnon ,	branch)	VALUES(	param1emp_no ,	param1rdate ,	param1rtime ,	param1rdescription ,	param1rdes_reasnon ,	param1branch); END $$DELIMITER ;#添加DELIMITER $$DROP PROCEDURE IF EXISTS proc_Insert_AttendrecordOutput $$CREATE PROCEDURE proc_Insert_AttendrecordOutput(	IN param1emp_no VarChar(20),	IN param1rdate Datetime,	IN param1rtime Time,	IN param1rdescription VarChar(100),	IN param1rdes_reasnon VarChar(100),	IN param1branch VarChar(50), 	out param1seq int)BEGININSERT INTO attendrecord(	emp_no ,	rdate ,	rtime ,	rdescription ,	rdes_reasnon ,	branch)	VALUES(	param1emp_no ,	param1rdate ,	param1rtime ,	param1rdescription ,	param1rdes_reasnon ,	param1branch);SELECT LAST_INSERT_ID() into param1seq;END $$DELIMITER ;

  

/// <summary>	/// Attendrecord数据访问层	///生成時間2016-9-6 17:24:08	///塗聚文(Geovin Du) 自建代码生成器生成(简单存储过程也可以生成)	///</summary>	public class AttendrecordDAL : IAttendrecord	{		///<summary>		/// 追加记录 存储过程		///</summary>		///<param name="AttendrecordInfo"></param>		///<returns></returns>		public int InsertAttendrecord(AttendrecordInfo attendrecord)		{			int ret = 0;			try			{				MySqlParameter[] par = new MySqlParameter[]{				new MySqlParameter("?param1emp_no",MySqlDbType.VarChar,20),				new MySqlParameter("?param1rdate",MySqlDbType.Datetime),				new MySqlParameter("?param1rtime",MySqlDbType.String), //涂聚文注:不能用MySqlDbType.Time否则报错:base {System.Data.Common.DbException} = {"Only TimeSpan objects can be serialized by MySqlTimeSpan"}				new MySqlParameter("?param1rdescription",MySqlDbType.VarChar,100),				new MySqlParameter("?param1rdes_reasnon",MySqlDbType.VarChar,100),				new MySqlParameter("?param1branch",MySqlDbType.VarChar,50),				};				par[0].Value = attendrecord.Emp_no;				par[1].Value = attendrecord.Rdate;        par[2].Value = attendrecord.Rtime;				par[3].Value = attendrecord.Rdescription;				par[4].Value = attendrecord.Rdes_reasnon;				par[5].Value = attendrecord.Branch;				ret = DBHelper.ExecuteSql("proc_Insert_Attendrecord", CommandType.StoredProcedure, par);			}			catch (MySqlException ex)			{				throw ex;			}			return ret;		}		///<summary>    /// 追加记录 SQL脚本		///</summary>		///<param name="AttendrecordInfo"></param>		///<returns></returns>		public int InsertSqlAttendrecord(AttendrecordInfo attendrecord)		{			int ret = 0;			try			{				StringBuilder strSql = new StringBuilder();				strSql.Append("INSERT INTO attendrecord(emp_no,rdate,rtime,rdescription,rdes_reasnon,branch");				strSql.Append(") VALUES (");				strSql.Append("?param1emp_no ,?param1rdate ,?param1rtime ,?param1rdescription ,?param1rdes_reasnon ,?param1branch)");				MySqlParameter[] par = new MySqlParameter[]{				new MySqlParameter("?param1emp_no",MySqlDbType.VarChar,20),				new MySqlParameter("?param1rdate",MySqlDbType.Datetime),				new MySqlParameter("?param1rtime",MySqlDbType.String),				new MySqlParameter("?param1rdescription",MySqlDbType.VarChar,100),				new MySqlParameter("?param1rdes_reasnon",MySqlDbType.VarChar,100),				new MySqlParameter("?param1branch",MySqlDbType.VarChar,50),				};				par[0].Value = attendrecord.Emp_no;				par[1].Value = attendrecord.Rdate;				par[2].Value = attendrecord.Rtime;				par[3].Value = attendrecord.Rdescription;				par[4].Value = attendrecord.Rdes_reasnon;				par[5].Value = attendrecord.Branch;				ret = DBHelper.ExecuteSql(strSql.ToString(), CommandType.Text, par);			}			catch (MySqlException ex)			{				throw ex;			}			return ret;		}

  




原标题:csharp: MySQL Stored Procedure using DAL

关键词:MYSQL

*特别声明:以上内容来自于网络收集,著作权属原作者所有,如有侵权,请联系我们: admin#shaoqun.com (#换成@)。

11月欧洲汽车销量“一片绿海” 马自达三菱等跌幅逾30%:https://www.ikjzd.com/articles/137766
晋江陆地港跨境电商零售出口单量超600万单:https://www.ikjzd.com/articles/137767
速卖通俄罗斯:11月初以来脉搏血氧仪销量同比增长30倍:https://www.ikjzd.com/articles/137768
eBay删除对接物流供应商京华达(KWT Logistics):https://www.ikjzd.com/articles/137769
因新冠病例增加 亚马逊临时关闭新泽西州一货仓:https://www.ikjzd.com/articles/137770
法国Quadient为英国零售商Frasers提供全自动包装系统:https://www.ikjzd.com/articles/137771
出境旅游预订须知:https://www.vstour.cn/a/365175.html
九寨沟景区地图(详细指南和攻略):https://www.vstour.cn/a/365176.html
相关文章
我的浏览记录
最新相关资讯
海外公司注册 | 跨境电商服务平台 | 深圳旅行社 | 东南亚物流