/// <summary> /// 增加一条数据 /// </summary> public int Add(VAN_OA.Model.EFrom.tb_Consignor model, SqlCommand objCommand) { StringBuilder strSql = new StringBuilder(); StringBuilder strSql1 = new StringBuilder(); StringBuilder strSql2 = new StringBuilder(); if (model.consignor != null) { strSql1.Append("consignor,"); strSql2.Append("" + model.consignor + ","); } if (model.appPer != null) { strSql1.Append("appPer,"); strSql2.Append("" + model.appPer + ","); } if (model.fromTime != null) { strSql1.Append("fromTime,"); strSql2.Append("'" + model.fromTime + "',"); } if (model.toTime != null) { strSql1.Append("toTime,"); strSql2.Append("'" + model.toTime + "',"); } if (model.ifYouXiao != null) { strSql1.Append("ifYouXiao,"); strSql2.Append("" + (model.ifYouXiao ? 1 : 0) + ","); } if (model.conState != null) { strSql1.Append("conState,"); strSql2.Append("'" + model.conState + "',"); } if (model.proId != null) { strSql1.Append("proId,"); strSql2.Append("" + model.proId + ","); } strSql.Append("insert into tb_Consignor("); strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1)); strSql.Append(")"); strSql.Append(" values ("); strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1)); strSql.Append(")"); strSql.Append(";select @@IDENTITY"); objCommand.CommandText = strSql.ToString(); object obj = objCommand.ExecuteScalar(); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(VAN_OA.Model.EFrom.tb_Consignor model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update tb_Consignor set "); if (model.consignor != null) { strSql.Append("consignor=" + model.consignor + ","); } if (model.appPer != null) { strSql.Append("appPer=" + model.appPer + ","); } if (model.fromTime != null) { strSql.Append("fromTime='" + model.fromTime + "',"); } else { strSql.Append("fromTime= null ,"); } if (model.toTime != null) { strSql.Append("toTime='" + model.toTime + "',"); } else { strSql.Append("toTime= null ,"); } if (model.ifYouXiao != null) { strSql.Append("ifYouXiao=" + (model.ifYouXiao ? 1 : 0) + ","); } if (model.conState != null) { strSql.Append("conState='" + model.conState + "',"); } if (model.proId != null) { strSql.Append("proId=" + model.proId + ","); } int n = strSql.ToString().LastIndexOf(","); strSql.Remove(n, 1); strSql.Append(" where con_Id=" + model.con_Id + ""); return(DBHelp.ExeCommand(strSql.ToString())); }
/// <summary> /// 对象实体绑定数据 /// </summary> public VAN_OA.Model.EFrom.tb_Consignor ReaderBind(IDataReader dataReader) { VAN_OA.Model.EFrom.tb_Consignor model = new VAN_OA.Model.EFrom.tb_Consignor(); object ojb; ojb = dataReader["con_Id"]; if (ojb != null && ojb != DBNull.Value) { model.con_Id = (int)ojb; } model.consignor = Convert.ToInt32(dataReader["consignor"]); ojb = dataReader["consignor_Name"]; if (ojb != null && ojb != DBNull.Value) { model.Consignor_Name = ojb.ToString(); } ojb = dataReader["appPer_Name"]; if (ojb != null && ojb != DBNull.Value) { model.Appper_Name = ojb.ToString(); } model.appPer = Convert.ToInt32(dataReader["appPer"]); ojb = dataReader["fromTime"]; if (ojb != null && ojb != DBNull.Value) { model.fromTime = (DateTime)ojb; } ojb = dataReader["toTime"]; if (ojb != null && ojb != DBNull.Value) { model.toTime = (DateTime)ojb; } ojb = dataReader["ifYouXiao"]; if (ojb != null && ojb != DBNull.Value) { model.ifYouXiao = (bool)ojb; } model.conState = dataReader["conState"].ToString(); ojb = dataReader["proId"]; if (ojb != null && ojb != DBNull.Value) { model.proId = (int)ojb; } model.ProType = dataReader["pro_Type"].ToString(); if (model.ifYouXiao == true) { model.Youxiaoqi = "一直有效"; } else { if (model.fromTime != null && model.toTime != null) { model.Youxiaoqi = Convert.ToDateTime(model.fromTime).ToShortDateString() + "--" + Convert.ToDateTime(model.toTime).ToShortDateString(); } else if (model.fromTime != null && model.toTime == null) { model.Youxiaoqi = "生效日期:" + Convert.ToDateTime(model.fromTime).ToShortDateString(); } else if (model.fromTime == null && model.toTime != null) { model.Youxiaoqi = "终止日期:" + Convert.ToDateTime(model.toTime).ToShortDateString(); } } return(model); }