/// <summary> /// 增加一条数据 /// </summary> public int Add(IPSP.Model.TCstmr_ClientFeePolicy model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into TCstmr_ClientFeePolicy("); strSql.Append("n_ClientID,n_ChargeCurrency,s_IPType,s_FeeMode,n_Value,s_Note,dt_EditDate,n_PayUnit,s_IPRole,s_FeeType,n_EndProcess,s_BusinessType,s_PTCType)"); strSql.Append(" values ("); strSql.Append("@n_ClientID,@n_ChargeCurrency,@s_IPType,@s_FeeMode,@n_Value,@s_Note,@dt_EditDate,@n_PayUnit,@s_IPRole,@s_FeeType,@n_EndProcess,@s_BusinessType,@s_PTCType)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@n_ClientID", SqlDbType.Int, 4), new SqlParameter("@n_ChargeCurrency", SqlDbType.Int, 4), new SqlParameter("@s_IPType", SqlDbType.NVarChar, 50), new SqlParameter("@s_FeeMode", SqlDbType.NVarChar, 1), new SqlParameter("@n_Value", SqlDbType.Decimal, 9), new SqlParameter("@s_Note", SqlDbType.NVarChar, 300), new SqlParameter("@dt_EditDate", SqlDbType.DateTime), new SqlParameter("@n_PayUnit", SqlDbType.Int, 4), new SqlParameter("@s_IPRole", SqlDbType.NVarChar, 50), new SqlParameter("@s_FeeType", SqlDbType.NVarChar, 1), new SqlParameter("@n_EndProcess", SqlDbType.Int, 4), new SqlParameter("@s_BusinessType", SqlDbType.VarChar, 200), new SqlParameter("@s_PTCType", SqlDbType.VarChar, 50) }; parameters[0].Value = model.n_ClientID; parameters[1].Value = model.n_ChargeCurrency; parameters[2].Value = model.s_IPType; parameters[3].Value = model.s_FeeMode; parameters[4].Value = model.n_Value; parameters[5].Value = model.s_Note; parameters[6].Value = model.dt_EditDate; parameters[7].Value = model.n_PayUnit; parameters[8].Value = model.s_IPRole; parameters[9].Value = model.s_FeeType; parameters[10].Value = model.n_EndProcess; parameters[11].Value = model.s_BusinessType; parameters[12].Value = model.s_PTCType; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public IPSP.Model.TCstmr_ClientFeePolicy GetModel(int n_ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 n_ID,n_ClientID,n_ChargeCurrency,s_IPType,s_FeeMode,n_Value,s_Note,dt_EditDate,n_PayUnit,s_IPRole,s_FeeType,n_EndProcess,s_BusinessType,s_PTCType from TCstmr_ClientFeePolicy "); strSql.Append(" where n_ID=@n_ID"); SqlParameter[] parameters = { new SqlParameter("@n_ID", SqlDbType.Int, 4) }; parameters[0].Value = n_ID; IPSP.Model.TCstmr_ClientFeePolicy model = new IPSP.Model.TCstmr_ClientFeePolicy(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(IPSP.Model.TCstmr_ClientFeePolicy model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(IPSP.Model.TCstmr_ClientFeePolicy model) { return(dal.Add(model)); }
/// <summary> /// 得到一个对象实体 /// </summary> public IPSP.Model.TCstmr_ClientFeePolicy DataRowToModel(DataRow row) { IPSP.Model.TCstmr_ClientFeePolicy model = new IPSP.Model.TCstmr_ClientFeePolicy(); if (row != null) { if (row["n_ID"] != null && row["n_ID"].ToString() != "") { model.n_ID = int.Parse(row["n_ID"].ToString()); } if (row["n_ClientID"] != null && row["n_ClientID"].ToString() != "") { model.n_ClientID = int.Parse(row["n_ClientID"].ToString()); } if (row["n_ChargeCurrency"] != null && row["n_ChargeCurrency"].ToString() != "") { model.n_ChargeCurrency = int.Parse(row["n_ChargeCurrency"].ToString()); } if (row["s_IPType"] != null) { model.s_IPType = row["s_IPType"].ToString(); } if (row["s_FeeMode"] != null) { model.s_FeeMode = row["s_FeeMode"].ToString(); } if (row["n_Value"] != null && row["n_Value"].ToString() != "") { model.n_Value = decimal.Parse(row["n_Value"].ToString()); } if (row["s_Note"] != null) { model.s_Note = row["s_Note"].ToString(); } if (row["dt_EditDate"] != null && row["dt_EditDate"].ToString() != "") { model.dt_EditDate = DateTime.Parse(row["dt_EditDate"].ToString()); } if (row["n_PayUnit"] != null && row["n_PayUnit"].ToString() != "") { model.n_PayUnit = int.Parse(row["n_PayUnit"].ToString()); } if (row["s_IPRole"] != null) { model.s_IPRole = row["s_IPRole"].ToString(); } if (row["s_FeeType"] != null) { model.s_FeeType = row["s_FeeType"].ToString(); } if (row["n_EndProcess"] != null && row["n_EndProcess"].ToString() != "") { model.n_EndProcess = int.Parse(row["n_EndProcess"].ToString()); } if (row["s_BusinessType"] != null) { model.s_BusinessType = row["s_BusinessType"].ToString(); } if (row["s_PTCType"] != null) { model.s_PTCType = row["s_PTCType"].ToString(); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(IPSP.Model.TCstmr_ClientFeePolicy model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update TCstmr_ClientFeePolicy set "); strSql.Append("n_ChargeCurrency=@n_ChargeCurrency,"); strSql.Append("s_IPType=@s_IPType,"); strSql.Append("s_FeeMode=@s_FeeMode,"); strSql.Append("n_Value=@n_Value,"); strSql.Append("s_Note=@s_Note,"); strSql.Append("dt_EditDate=@dt_EditDate,"); strSql.Append("n_PayUnit=@n_PayUnit,"); strSql.Append("s_IPRole=@s_IPRole,"); strSql.Append("s_FeeType=@s_FeeType,"); strSql.Append("n_EndProcess=@n_EndProcess,"); strSql.Append("s_BusinessType=@s_BusinessType,"); strSql.Append("s_PTCType=@s_PTCType"); strSql.Append(" where n_ID=@n_ID"); SqlParameter[] parameters = { new SqlParameter("@n_ChargeCurrency", SqlDbType.Int, 4), new SqlParameter("@s_IPType", SqlDbType.NVarChar, 50), new SqlParameter("@s_FeeMode", SqlDbType.NVarChar, 1), new SqlParameter("@n_Value", SqlDbType.Decimal, 9), new SqlParameter("@s_Note", SqlDbType.NVarChar, 300), new SqlParameter("@dt_EditDate", SqlDbType.DateTime), new SqlParameter("@n_PayUnit", SqlDbType.Int, 4), new SqlParameter("@s_IPRole", SqlDbType.NVarChar, 50), new SqlParameter("@s_FeeType", SqlDbType.NVarChar, 1), new SqlParameter("@n_EndProcess", SqlDbType.Int, 4), new SqlParameter("@s_BusinessType", SqlDbType.VarChar, 200), new SqlParameter("@s_PTCType", SqlDbType.VarChar, 50), new SqlParameter("@n_ID", SqlDbType.Int, 4), new SqlParameter("@n_ClientID", SqlDbType.Int, 4) }; parameters[0].Value = model.n_ChargeCurrency; parameters[1].Value = model.s_IPType; parameters[2].Value = model.s_FeeMode; parameters[3].Value = model.n_Value; parameters[4].Value = model.s_Note; parameters[5].Value = model.dt_EditDate; parameters[6].Value = model.n_PayUnit; parameters[7].Value = model.s_IPRole; parameters[8].Value = model.s_FeeType; parameters[9].Value = model.n_EndProcess; parameters[10].Value = model.s_BusinessType; parameters[11].Value = model.s_PTCType; parameters[12].Value = model.n_ID; parameters[13].Value = model.n_ClientID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }