/// <summary> /// 增加一条数据 /// </summary> public int Add(VAN_OA.Model.Fin.FIN_SpecCost model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into FIN_SpecCost("); strSql.Append("ProNo,CostTypeId,Total,CaiYear,CompId,UserID"); 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("" + model.UserID + ""); 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_SpecCost model, SqlCommand objCommand) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into FIN_SpecCost("); strSql.Append("ProNo,CostTypeId,Total,CaiYear,CompId,UserID"); 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("" + model.UserID + ""); 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_SpecCost model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update FIN_SpecCost set "); strSql.Append("ProNo='" + model.ProNo + "',"); strSql.Append("CostTypeId=" + model.CostTypeId + ","); strSql.Append("UserID=" + model.UserID + ","); 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_SpecCost ReaderBind(IDataReader dataReader) { VAN_OA.Model.Fin.FIN_SpecCost model = new VAN_OA.Model.Fin.FIN_SpecCost(); 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"]); model.UserID = Convert.ToInt32(dataReader["UserID"]); return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public VAN_OA.Model.Fin.FIN_SpecCost GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select Id,ProNo,CostTypeId,Total,CaiYear,CompId,UserID "); strSql.Append(" FROM FIN_SpecCost "); strSql.Append(" where ID=" + ID + ""); VAN_OA.Model.Fin.FIN_SpecCost 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); }