public void Delete(Discount discount)
{
throw new NotImplementedException();
}
public bool AddClientAndDiscount(Client client, Discount discount)
{
Hashtable sqlhash = new Hashtable();
StringBuilder strsql = new StringBuilder();
strsql.Append("insert into T_Discount(");
strsql.Append("Dis_Name,Dis_ClientCode,Dis_CreateDate,Dis_ClearDate,Dis_Discount,Dis_Enable,Dis_Clear,Dis_Remark,Dis_Code");
strsql.Append(") values (");
strsql.Append("@Dis_Name,@Dis_ClientCode,@Dis_CreateDate,@Dis_ClearDate,@Dis_Discount,@Dis_Enable,@Dis_Clear,@Dis_Remark,@Dis_Code)");
SqlParameter[] disParameters =
{
new SqlParameter("@Dis_Name", SqlDbType.NVarChar, 512),
new SqlParameter("@Dis_ClientCode", SqlDbType.NVarChar, 512),
new SqlParameter("@Dis_CreateDate", SqlDbType.DateTime),
new SqlParameter("@Dis_ClearDate", SqlDbType.DateTime),
new SqlParameter("@Dis_Discount", SqlDbType.NVarChar, 512),
new SqlParameter("@Dis_Enable", SqlDbType.Int, 4),
new SqlParameter("@Dis_Clear", SqlDbType.Int, 4),
new SqlParameter("@Dis_Remark", SqlDbType.NVarChar, 1024),
new SqlParameter("@Dis_Code", SqlDbType.NVarChar, 512),
};
disParameters[0].Value = discount.Dis_Name;
disParameters[1].Value = discount.Dis_ClientCode;
disParameters[2].Value = discount.Dis_CreateDate;
disParameters[3].Value = discount.Dis_ClearDate;
disParameters[4].Value = discount.Dis_Discount;
disParameters[5].Value = discount.Dis_Enable;
disParameters[6].Value = discount.Dis_Clear;
disParameters[7].Value = discount.Dis_Remark;
disParameters[8].Value = discount.Dis_Code;
sqlhash.Add(strsql.ToString(), disParameters);
strsql = new StringBuilder();
strsql.Append("insert into T_Client(");
strsql.Append("Cli_Code,Cli_zhiwen,Cli_Name,Cli_PicName,Cli_Phone,Cli_PhoneTwo,Cli_faxes,Cli_CityCode,Cli_area,Cli_Address,Cli_LinkMan,Cli_Company,Cli_TypeCode,Cli_TypeName,Cli_DiscountCode,Cli_Bankaccounts,Cli_OpenBank,Cli_Olddata,Cli_Oldreturn,Cli_Newoutdata,Cli_Newintodata,Cli_Createdata,Cli_Limit,Cli_RemainLimit,Cli_ClearLimitdate,Cli_ShouldMoney,Cli_GetMoney,Cli_PreMoney,Cli_Remark,Cli_safetone,Cli_safettwo,Cli_Enable)");
strsql.Append(" values (");
strsql.Append("@Cli_Code,@Cli_zhiwen,@Cli_Name,@Cli_PicName,@Cli_Phone,@Cli_PhoneTwo,@Cli_faxes,@Cli_CityCode,@Cli_area,@Cli_Address,@Cli_LinkMan,@Cli_Company,@Cli_TypeCode,@Cli_TypeName,@Cli_DiscountCode,@Cli_Bankaccounts,@Cli_OpenBank,@Cli_Olddata,@Cli_Oldreturn,@Cli_Newoutdata,@Cli_Newintodata,@Cli_Createdata,@Cli_Limit,@Cli_RemainLimit,@Cli_ClearLimitdate,@Cli_ShouldMoney,@Cli_GetMoney,@Cli_PreMoney,@Cli_Remark,@Cli_safetone,@Cli_safettwo,@Cli_Enable)");
SqlParameter[] cliParameters =
{
new SqlParameter("@Cli_Code", SqlDbType.NVarChar, 512),
new SqlParameter("@Cli_zhiwen", SqlDbType.NVarChar, -1),
new SqlParameter("@Cli_Name", SqlDbType.NVarChar, 512),
new SqlParameter("@Cli_PicName", SqlDbType.NVarChar, 512),
new SqlParameter("@Cli_Phone", SqlDbType.NVarChar, 512),
new SqlParameter("@Cli_PhoneTwo", SqlDbType.NVarChar, 512),
new SqlParameter("@Cli_faxes", SqlDbType.NVarChar, 512),
new SqlParameter("@Cli_CityCode", SqlDbType.NVarChar, 512),
new SqlParameter("@Cli_area", SqlDbType.NVarChar, 512),
new SqlParameter("@Cli_Address", SqlDbType.NVarChar, 512),
new SqlParameter("@Cli_LinkMan", SqlDbType.NVarChar, 512),
new SqlParameter("@Cli_Company", SqlDbType.NVarChar, 512),
new SqlParameter("@Cli_TypeCode", SqlDbType.NVarChar, 512),
new SqlParameter("@Cli_TypeName", SqlDbType.NVarChar, 512),
new SqlParameter("@Cli_DiscountCode", SqlDbType.NVarChar, 512),
new SqlParameter("@Cli_Bankaccounts", SqlDbType.NVarChar, 512),
new SqlParameter("@Cli_OpenBank", SqlDbType.NVarChar, 512),
new SqlParameter("@Cli_Olddata", SqlDbType.DateTime),
new SqlParameter("@Cli_Oldreturn", SqlDbType.DateTime),
new SqlParameter("@Cli_Newoutdata", SqlDbType.DateTime),
new SqlParameter("@Cli_Newintodata", SqlDbType.DateTime),
new SqlParameter("@Cli_Createdata", SqlDbType.DateTime),
new SqlParameter("@Cli_Limit", SqlDbType.NVarChar, 512),
new SqlParameter("@Cli_RemainLimit", SqlDbType.NVarChar, 512),
new SqlParameter("@Cli_ClearLimitdate", SqlDbType.NVarChar, 512),
new SqlParameter("@Cli_ShouldMoney", SqlDbType.NVarChar, 512),
new SqlParameter("@Cli_GetMoney", SqlDbType.NVarChar, 512),
new SqlParameter("@Cli_PreMoney", SqlDbType.NVarChar, 512),
new SqlParameter("@Cli_Remark", SqlDbType.NVarChar, 1024),
new SqlParameter("@Cli_safetone", SqlDbType.NVarChar, 512),
new SqlParameter("@Cli_safettwo", SqlDbType.NVarChar, 512),
new SqlParameter("@Cli_Enable", SqlDbType.Int, 4)
};
cliParameters[0].Value = client.Cli_Code;
cliParameters[1].Value = client.Cli_zhiwen;
cliParameters[2].Value = client.Cli_Name;
cliParameters[3].Value = client.Cli_PicName;
cliParameters[4].Value = client.Cli_Phone;
cliParameters[5].Value = client.Cli_PhoneTwo;
cliParameters[6].Value = client.Cli_faxes;
cliParameters[7].Value = client.Cli_TypeCode;
cliParameters[8].Value = client.Cli_area;
cliParameters[9].Value = client.Cli_Address;
cliParameters[10].Value = client.Cli_LinkMan;
cliParameters[11].Value = client.Cli_Company;
cliParameters[12].Value = client.Cli_TypeCode;
cliParameters[13].Value = client.Cli_TypeName;
cliParameters[14].Value = client.Cli_DiscountCode;
cliParameters[15].Value = client.Cli_Bankaccounts;
cliParameters[16].Value = client.Cli_OpenBank;
cliParameters[17].Value = client.Cli_Olddata;
cliParameters[18].Value = client.Cli_Oldreturn;
cliParameters[19].Value = client.Cli_Newoutdata;
cliParameters[20].Value = client.Cli_Newintodata;
cliParameters[21].Value = client.Cli_Createdata;
cliParameters[22].Value = client.Cli_Limit;
cliParameters[23].Value = client.Cli_RemainLimit;
cliParameters[24].Value = client.Cli_ClearLimitdate;
cliParameters[25].Value = client.Cli_ShouldMoney;
cliParameters[26].Value = client.Cli_GetMoney;
cliParameters[27].Value = client.Cli_PreMoney;
cliParameters[28].Value = client.Cli_Remark;
cliParameters[29].Value = client.Cli_safetone;
cliParameters[30].Value = client.Cli_safettwo;
cliParameters[31].Value = client.Cli_Enable;
sqlhash.Add(strsql.ToString(), cliParameters);
try
{
DbHelperSQL.ExecuteSqlTran(sqlhash);
return(true);
}
catch (Exception)
{
throw;
}
}
public void Insert(Discount discount)
{
throw new NotImplementedException();
}
