/// <summary> /// dataset转成list /// </summary> private List <BaseInfo_Scx_M> DsToList(DataSet ds) { List <BaseInfo_Scx_M> list = new List <BaseInfo_Scx_M>(); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { BaseInfo_Scx_M model = null; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { model = new BaseInfo_Scx_M(); model.ScxID = int.Parse(ds.Tables[0].Rows[i]["ScxID"].ToString().Trim()); model.ScxCode = ds.Tables[0].Rows[i]["ScxCode"].ToString(); model.ScxName = ds.Tables[0].Rows[i]["ScxName"].ToString(); model.Fct = ds.Tables[0].Rows[i]["Fct"].ToString(); model.WorkCast = decimal.Parse(ds.Tables[0].Rows[i]["WorkCast"].ToString().Trim()); model.Currency = ds.Tables[0].Rows[i]["Currency"].ToString(); model.UpName = ds.Tables[0].Rows[i]["UpName"].ToString(); model.UpTime = DateTime.Parse(ds.Tables[0].Rows[i]["UpTime"].ToString().Trim()); if (ds.Tables[0].Rows[i]["Del"].ToString() != "") { model.Del = int.Parse(ds.Tables[0].Rows[i]["Del"].ToString()); } if (ds.Tables[0].Rows[i]["State"].ToString() != "") { model.State = int.Parse(ds.Tables[0].Rows[i]["State"].ToString()); } list.Add(model); } } return(list); }
/// <summary> /// 更新一条记录 /// </summary> /// <param name="model">数据模型</param> public bool Update(BaseInfo_Scx_M model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update ZL_BaseInfo_Scx "); strSql.Append("ScxCode=@ScxCode, "); strSql.Append("ScxName=@ScxName, "); strSql.Append("Fct=@Fct, "); strSql.Append("WorkCast=@WorkCast, "); strSql.Append("Currency=@Currency, "); strSql.Append("UpName=@UpName, "); strSql.Append("UpTime=@UpTime, "); strSql.Append("Del=@Del "); strSql.Append(" where ScxID=@ScxID "); SqlParameter[] parameters = { new SqlParameter("@ScxID", SqlDbType.Int, 4), new SqlParameter("@ScxCode", SqlDbType.VarChar, 50), new SqlParameter("@ScxName", SqlDbType.VarChar, 100), new SqlParameter("@Fct", SqlDbType.VarChar, 25), new SqlParameter("@WorkCast", SqlDbType.Decimal), new SqlParameter("@Currency", SqlDbType.VarChar, 50), new SqlParameter("@UpName", SqlDbType.VarChar, 50), new SqlParameter("@UpTime", SqlDbType.DateTime), new SqlParameter("@Del", SqlDbType.Int, 4) }; parameters[0].Value = model.ScxID; parameters[1].Value = model.ScxCode; parameters[2].Value = model.ScxName; parameters[3].Value = model.Fct; parameters[4].Value = model.WorkCast; parameters[5].Value = model.Currency; parameters[6].Value = model.WorkCast; parameters[7].Value = model.UpName; parameters[8].Value = model.Del; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条记录 /// </summary> /// <param name="model">数据模型</param> public bool Add(BaseInfo_Scx_M model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into ITC_Buttons("); strSql.Append(" ScxCode, ScxName, Fct, WorkCast, Currency, UpName, UpTime, Del"); strSql.Append(") values ("); strSql.Append("@ScxCode, @ScxName, @Fct, @WorkCast, @Currency, @UpName, @UpTime, @Del"); strSql.Append(") "); SqlParameter[] parameters = { new SqlParameter("@ScxCode", SqlDbType.VarChar, 50), new SqlParameter("@ScxName", SqlDbType.VarChar, 100), new SqlParameter("@Fct", SqlDbType.VarChar, 25), new SqlParameter("@WorkCast", SqlDbType.Decimal), new SqlParameter("@Currency", SqlDbType.VarChar, 50), new SqlParameter("@UpName", SqlDbType.VarChar, 50), new SqlParameter("@UpTime", SqlDbType.DateTime), new SqlParameter("@Del", SqlDbType.Int, 4) }; parameters[0].Value = model.ScxCode; parameters[1].Value = model.ScxName; parameters[2].Value = model.Fct; parameters[3].Value = model.WorkCast; parameters[4].Value = model.Currency; parameters[5].Value = model.WorkCast; parameters[6].Value = model.UpName; parameters[7].Value = model.Del; int result = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (result > 0) { return(true); } else { return(false); } }
/// <summary> /// 修改 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool Update(BaseInfo_Scx_M model) { return(dal.Update(model)); }
/// <summary> /// 添加 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool Add(BaseInfo_Scx_M model) { return(dal.Add(model)); }
/// <summary> /// 操作信息 /// </summary> /// <param name="bid"></param> /// <returns></returns> public string GetButtonName(string bid) { BaseInfo_Scx_M model = GetModel(bid); return(model != null ? model.ScxName : ""); }