/// <summary> /// 增加一条数据 /// </summary> public int Add(VAN_OA.Model.Fin.FIN_CommCost model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into FIN_CommCost("); strSql.Append("ProNo,CostTypeId,Total,CaiYear,CompId"); strSql.Append(")"); strSql.Append(" values ("); strSql.Append("'" + model.ProNo + "',"); strSql.Append("" + model.CostTypeId + ","); strSql.Append("" + model.Total + ","); strSql.Append("'" + model.CaiYear + "',"); strSql.Append("" + model.CompId + ""); strSql.Append(")"); strSql.Append(";select @@IDENTITY"); object obj = DBHelp.ExeScalar(strSql.ToString()); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(VAN_OA.Model.Fin.FIN_CommCost model, SqlCommand objCommand) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into FIN_CommCost("); strSql.Append("ProNo,CostTypeId,Total,CaiYear,CompId"); strSql.Append(")"); strSql.Append(" values ("); strSql.Append("'" + GetAllE_No(objCommand) + "',"); strSql.Append("" + model.CostTypeId + ","); strSql.Append("" + model.Total + ","); strSql.Append("'" + model.CaiYear + "',"); strSql.Append("" + model.CompId + ""); strSql.Append(")"); strSql.Append(";select @@IDENTITY"); objCommand.CommandText = strSql.ToString(); int result; object obj = objCommand.ExecuteScalar(); if (!int.TryParse(obj.ToString(), out result)) { return(0); } return(result); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(VAN_OA.Model.Fin.FIN_CommCost model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update FIN_CommCost set "); strSql.Append("ProNo='" + model.ProNo + "',"); strSql.Append("CostTypeId=" + model.CostTypeId + ","); strSql.Append("Total=" + model.Total + ","); strSql.Append("CaiYear='" + model.CaiYear + "',"); strSql.Append("CompId=" + model.CompId + ""); strSql.Append(" where Id=" + model.Id + ""); bool rowsAffected = DBHelp.ExeCommand(strSql.ToString()); return(rowsAffected); }
/// <summary> /// 对象实体绑定数据 /// </summary> public VAN_OA.Model.Fin.FIN_CommCost ReaderBind(IDataReader dataReader) { VAN_OA.Model.Fin.FIN_CommCost model = new VAN_OA.Model.Fin.FIN_CommCost(); object ojb; ojb = dataReader["Id"]; if (ojb != null && ojb != DBNull.Value) { model.Id = (int)ojb; } model.ProNo = dataReader["ProNo"].ToString(); model.CostTypeId = Convert.ToInt32(dataReader["CostTypeId"]); ojb = dataReader["Total"]; if (ojb != null && ojb != DBNull.Value) { model.Total = (decimal)ojb; } model.CaiYear = dataReader["CaiYear"].ToString(); model.CompId = Convert.ToInt32(dataReader["CompId"]); return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public VAN_OA.Model.Fin.FIN_CommCost GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select Id,ProNo,CostTypeId,Total,CaiYear,CompId "); strSql.Append(" FROM FIN_CommCost "); strSql.Append(" where ID=" + ID + ""); VAN_OA.Model.Fin.FIN_CommCost model = null; using (SqlConnection conn = DBHelp.getConn()) { conn.Open(); SqlCommand objCommand = new SqlCommand(strSql.ToString(), conn); using (SqlDataReader objReader = objCommand.ExecuteReader()) { if (objReader.Read()) { model = ReaderBind(objReader); } } } return(model); }