/// <summary>
/// 存档
/// </summary>
/// <param name="userm">项目信息类（模型层）</param>
/// <returns>T=存档成功；F=存档失败</returns>
public bool Save()
{
string fields = string.Format("{0},{1}", TableStructM.Info_Projects.PR_NAME, TableStructM.Info_Projects.PR_BELONG);
string values = string.Format("{0},{1}", "@pr_name", "@pr_belong");
List <IDataParameter> lstParam = new List <IDataParameter>();
_dbfactory.AddParameter(lstParam, "@pr_name", this._projectsm.PRName);
_dbfactory.AddParameter(lstParam, "@pr_belong", this._projectsm.PRBelong);
int effect = this._dbfactory.Insert(TableStructM.Info_Projects.TABLENAME, fields, values, lstParam);
return(effect > 0);
}
/// <summary>
/// 存档
/// </summary>
/// <param name="userm">项目信息类（模型层）</param>
/// <returns>T=存档成功；F=存档失败</returns>
public bool Save()
{
string fields = string.Format("{0}", TableStructM.Info_ProjectTeam.PT_NAME);
string values = string.Format("{0}", "@pt_name");
List <IDataParameter> lstParam = new List <IDataParameter>();
_dbfactory.AddParameter(lstParam, "@pr_name", this._projectsteamm.PTName);
int effect = this._dbfactory.Insert(TableStructM.Info_ProjectTeam.TABLENAME, fields, values, lstParam);
return(effect > 0);
}
/// <summary>
/// 存档
/// </summary>
/// <param name="clientsm">客户信息类（模型层）</param>
/// <returns>T=存档成功；F=存档失败</returns>
public bool Save()
{
string fields = string.Format("{0},{1},{2},{3},{4},{5},{6},{7}", TableStructM.Info_Clients.CL_ACCOUNT, TableStructM.Info_Clients.CL_ADDRESS, TableStructM.Info_Clients.CL_BANK, TableStructM.Info_Clients.CL_BELONG, TableStructM.Info_Clients.CL_CODE, TableStructM.Info_Clients.CL_NAME, TableStructM.Info_Clients.CL_PERSON, TableStructM.Info_Clients.CL_TEL);
string values = string.Format("{0},{1},{2},{3},{4},{5},{6},{7}", "@cl_account", "@cl_address", "@cl_bank", "@cl_belong", "@cl_code", "@cl_name", "@cl_person", "@cl_tel");
List <IDataParameter> lstParam = new List <IDataParameter>();
_dbfactory.AddParameter(lstParam, "@cl_account", this._clientsm.CLACCOUNT);
_dbfactory.AddParameter(lstParam, "@cl_address", this._clientsm.CLADDRESS);
_dbfactory.AddParameter(lstParam, "@cl_bank", this._clientsm.CLBANK);
_dbfactory.AddParameter(lstParam, "@cl_belong", this._clientsm.CLBELONG);
_dbfactory.AddParameter(lstParam, "@cl_code", this._clientsm.CLCODE);
_dbfactory.AddParameter(lstParam, "@cl_name", this._clientsm.CLNAME);
_dbfactory.AddParameter(lstParam, "@cl_person", this._clientsm.CLPERSON);
_dbfactory.AddParameter(lstParam, "@cl_tel", this._clientsm.CLTEL);
int effect = this._dbfactory.Insert(TableStructM.Info_Clients.TABLENAME, fields, values, lstParam);
return(effect > 0);
}
/// <summary>
/// 存档
/// </summary>
/// <param name="userm">工程量信息类（模型层）</param>
/// <returns>T=存档成功；F=存档失败</returns>
public bool Save()
{
string fields = string.Format("{0},{1},{2},{3},{4},{5}, {6}, {7}", TableStructM.Info_Quantity.QT_PRID, TableStructM.Info_Quantity.QT_CNID, TableStructM.Info_Quantity.QT_CLID, TableStructM.Info_Quantity.QT_CONTENT, TableStructM.Info_Quantity.QT_QUANTITY, TableStructM.Info_Quantity.QT_MEASUREMENT, TableStructM.Info_Quantity.QT_PRICE, TableStructM.Info_Quantity.QT_MONEY);
string values = string.Format("{0},{1},{2},{3},{4},{5}, {6}, {7}", "@qt_prid", "@qt_cnid", "@qt_clid", "@qt_content", "@qt_quantity", "@qt_measurement", "@qt_price", "@qt_money");
List <IDataParameter> lstParam = new List <IDataParameter>();
_dbfactory.AddParameter(lstParam, "@qt_prid", this._quantitym.QTPRID);
_dbfactory.AddParameter(lstParam, "@qt_cnid", this._quantitym.QTCNID);
_dbfactory.AddParameter(lstParam, "@qt_clid", this._quantitym.QTCLID);
_dbfactory.AddParameter(lstParam, "@qt_content", this._quantitym.QTCONTENT);
_dbfactory.AddParameter(lstParam, "@qt_quantity", this._quantitym.QTQUANTITY);
_dbfactory.AddParameter(lstParam, "@qt_measurement", this._quantitym.QTMEASUREMENT);
_dbfactory.AddParameter(lstParam, "@qt_price", this._quantitym.QTPRICE);
_dbfactory.AddParameter(lstParam, "@qt_money", this._quantitym.QTMONEY);
int effect = this._dbfactory.Insert(TableStructM.Info_Quantity.TABLENAME, fields, values, lstParam);
return(effect > 0);
}
/// <summary>
/// 存档
/// </summary>
/// <param name="userm">收付款信息类（模型层）</param>
/// <returns>T=存档成功；F=存档失败</returns>
public bool Save()
{
string fields = string.Format("{0},{1},{2},{3},{4},{5},{6}", TableStructM.Info_Finance.SF_COLLECTPAY, TableStructM.Info_Finance.SF_PRID, TableStructM.Info_Finance.SF_CNID, TableStructM.Info_Finance.SF_DATE, TableStructM.Info_Finance.SF_MONEY, TableStructM.Info_Finance.SF_ACCOUNT, TableStructM.Info_Finance.SF_CLID);
string values = string.Format("{0},{1},{2},{3},{4},{5}", "@sf_collectpay", "@sf_prid", "@sf_cnid", "@sf_date", "@sf_money", "@sf_account", "@sf_clid");
List <IDataParameter> lstParam = new List <IDataParameter>();
_dbfactory.AddParameter(lstParam, "@sf_collectpay", this._financem.SFCOLLECTPAY);
_dbfactory.AddParameter(lstParam, "@sf_prid", this._financem.SFPRID);
_dbfactory.AddParameter(lstParam, "@sf_cnid", this._financem.SFCNID);
_dbfactory.AddParameter(lstParam, "@sf_clid", this._financem.SFCLID);
_dbfactory.AddParameter(lstParam, "@sf_date", this._financem.SFDATE);
_dbfactory.AddParameter(lstParam, "@sf_money", this._financem.SFMONEY);
_dbfactory.AddParameter(lstParam, "@sf_account", this._financem.SFACCOUNT);
int effect = this._dbfactory.Insert(TableStructM.Info_Finance.TABLENAME, fields, values, lstParam);
return(effect > 0);
}
/// <summary>
/// 存档
/// </summary>
/// <param name="userm">合同信息类（模型层）</param>
/// <returns>T=存档成功；F=存档失败</returns>
public bool Save()
{
string fields = string.Format("{0},{1},{2},{3},{4},{5},{6}", TableStructM.Info_Contract.CT_PRID, TableStructM.Info_Contract.CT_NAME, TableStructM.Info_Contract.CT_NO, TableStructM.Info_Contract.CT_CLID, TableStructM.Info_Contract.CT_MONEY, TableStructM.Info_Contract.CT_DATE, TableStructM.Info_Contract.CT_BELONG);
string values = string.Format("{0},{1},{2},{3},{4},{5},{6}", "@ct_prid", "@ct_name", "@ct_no", "@ct_clid", "@ct_money", "@ct_date", "@ct_belong");
List <IDataParameter> lstParam = new List <IDataParameter>();
_dbfactory.AddParameter(lstParam, "@ct_prid", this._contractm.CTPrid);
_dbfactory.AddParameter(lstParam, "@ct_name", this._contractm.CTName);
_dbfactory.AddParameter(lstParam, "@ct_no", this._contractm.CTNo);
_dbfactory.AddParameter(lstParam, "@ct_clid", this._contractm.CTClid);
_dbfactory.AddParameter(lstParam, "@ct_money", this._contractm.CTMoney);
_dbfactory.AddParameter(lstParam, "@ct_date", this._contractm.CTDate);
_dbfactory.AddParameter(lstParam, "@ct_belong", this._contractm.CTBelong);
int effect = this._dbfactory.Insert(TableStructM.Info_Contract.TABLENAME, fields, values, lstParam);
return(effect > 0);
}