/// <summary>
/// 修改合同状态
/// </summary>
/// <param name="id"></param>
/// <param name="state"></param>
/// <returns></returns>
public JsonResult ContractList_editContractState(string id, string state)
{
DaContractInfo dal = new DaContractInfo();
ContractInfo en = new ContractInfo();
en.contractID = id;
en.state = Convert.ToInt32(state);
var result = new CustomJsonResult();
result.Data = dal.editContractState(en);
return result;
}
public JsonResult ContractList_editContract(string id, string name, string version, string price, string num,
string money, string make, string back, string type, string channel, string begintime, string endtime,
string zq, string person, string mDate, string memo)
{
ContractInfo en = new ContractInfo();
en.contractID = id;
en.name = name;
en.version = version;
if (price.Trim() != "")
en.price = Convert.ToDouble(price);
if (num.Trim() != "")
en.roomNum = Convert.ToInt32(num);
if (money.Trim() != "")
en.money = Convert.ToDouble(money);
if (make.Trim() != "")
en.makeCost = Convert.ToDouble(make);
if (back.Trim() != "")
en.backMoney = Convert.ToDouble(back);
if (type.Trim() != "")
en.type = Convert.ToInt32(type);
if (channel.Trim() != "")
en.channelID = Convert.ToInt32(channel);
if (begintime.Trim() != "")
en.begintime = Convert.ToDateTime(begintime);
if (endtime.Trim() != "")
en.endtime = Convert.ToDateTime(endtime);
if (zq.Trim() != "")
en.ZQ = Convert.ToDouble(zq);
if (person.Trim() != "")
en.personID = Convert.ToInt32(person);
if (mDate.Trim() != "")
en.mDate = Convert.ToDateTime(mDate);
en.memo = memo;
DaContractInfo dal = new DaContractInfo();
var result = new CustomJsonResult();
result.Data = dal.update(en);
return result;
}
/// <summary>
/// 添加合同
/// </summary>
/// <param name="en">实体</param>
/// <returns></returns>
public int add(ContractInfo en)
{
string strSql = "insert into ContractInfo (contractID, name, customerID, version, price, roomNum, makeCost, backMoney, money, type, channelID, begintime, endtime, ZQ, personID, memo, mDate, billState) "
+ "values (@contractID, @name, @customerID, @version, @price, @roomNum, @makeCost, @backMoney, @money, @type, @channelID, @begintime, @endtime, @ZQ, @personID, @memo, @mDate, @billState)";
SqlParameter[] param = new SqlParameter[18];
param[0] = new SqlParameter("@contractID", en.contractID);
if (en.name.Trim() == "")
param[1] = new SqlParameter("@name", System.DBNull.Value);
else
param[1] = new SqlParameter("@name", en.name);
if (en.customerID == 0)
param[2] = new SqlParameter("@customerID", System.DBNull.Value);
else
param[2] = new SqlParameter("@customerID", en.customerID);
if (en.version.Trim() == "")
param[3] = new SqlParameter("@version", System.DBNull.Value);
else
param[3] = new SqlParameter("@version", en.version);
if (en.price == 0.0)
param[4] = new SqlParameter("@price", System.DBNull.Value);
else
param[4] = new SqlParameter("@price", en.price);
if (en.roomNum == 0)
param[5] = new SqlParameter("@roomNum", System.DBNull.Value);
else
param[5] = new SqlParameter("@roomNum", en.roomNum);
if (en.makeCost == 0.0)
param[6] = new SqlParameter("@makeCost", System.DBNull.Value);
else
param[6] = new SqlParameter("@makeCost", en.makeCost);
if (en.backMoney == 0.0)
param[7] = new SqlParameter("@backMoney", System.DBNull.Value);
else
param[7] = new SqlParameter("@backMoney", en.backMoney);
if (en.money == 0.0)
param[8] = new SqlParameter("@money", System.DBNull.Value);
else
param[8] = new SqlParameter("@money", en.money);
if (en.type == 0)
param[9] = new SqlParameter("@type", System.DBNull.Value);
else
param[9] = new SqlParameter("@type", en.type);
if (en.channelID == 0)
param[10] = new SqlParameter("@channelID", System.DBNull.Value);
else
param[10] = new SqlParameter("@channelID", en.channelID);
if (en.begintime == null)
param[11] = new SqlParameter("@begintime", System.DBNull.Value);
else
param[11] = new SqlParameter("@begintime", en.begintime);
if (en.endtime == null)
param[12] = new SqlParameter("@endtime", System.DBNull.Value);
else
param[12] = new SqlParameter("@endtime", en.endtime);
if (en.ZQ == 0.0)
param[13] = new SqlParameter("@ZQ", System.DBNull.Value);
else
param[13] = new SqlParameter("@ZQ", en.ZQ);
if (en.personID == 0)
param[14] = new SqlParameter("@personID", System.DBNull.Value);
else
param[14] = new SqlParameter("@personID", en.personID);
if (en.memo.Trim() == "")
param[15] = new SqlParameter("@memo", System.DBNull.Value);
else
param[15] = new SqlParameter("@memo", en.memo);
if (en.mDate == null)
param[16] = new SqlParameter("@mDate", System.DBNull.Value);
else
param[16] = new SqlParameter("@mDate", en.mDate);
if (en.billState == 0)
param[17] = new SqlParameter("@billState", System.DBNull.Value);
else
param[17] = new SqlParameter("@billState", en.billState);
int result = SqlHelper.ExecuteNonQuery(BaseHelper.DBConnStr, CommandType.Text, strSql, param);
return result;
}
/// <summary>
/// 修改合同
/// </summary>
/// <param name="en">实体</param>
/// <returns></returns>
public int update(ContractInfo en)
{
string strSql = "update ContractInfo set name=@name, customerID=@customerID, version=@version, "
+ "price=@price, roomNum=@roomNum, makeCost=@makeCost, backMoney=@backMoney, money=@money, type=@type, "
+ "channelID=@channelID, begintime=@begintime, endtime=@endtime, ZQ=@ZQ, personID=@personID, memo=@memo, "
+ "mDate=@mDate, billState=@billState, editTime=getDate() where contractID=@id ";
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@contractID", en.contractID),
new SqlParameter("@name", en.name),
new SqlParameter("@customerID", en.customerID),
new SqlParameter("@version", en.version),
new SqlParameter("@price", en.price),
new SqlParameter("@roomNum", en.roomNum),
new SqlParameter("@makeCost", en.makeCost),
new SqlParameter("@backMoney", en.backMoney),
new SqlParameter("@money", en.money),
new SqlParameter("@type", en.type),
new SqlParameter("@channelID", en.channelID),
new SqlParameter("@begintime", System.DBNull.Value),
new SqlParameter("@endtime", System.DBNull.Value),
new SqlParameter("@ZQ", en.ZQ),
new SqlParameter("@personID", en.personID),
new SqlParameter("@memo", en.memo),
new SqlParameter("@mDate", System.DBNull.Value),
new SqlParameter("@billState", en.billState)
};
if (en.begintime != null)
param[11].Value = en.begintime;
if (en.endtime != null)
param[12].Value = en.endtime;
if (en.mDate != null)
param[16].Value = en.mDate;
int result = SqlHelper.ExecuteNonQuery(BaseHelper.DBConnStr, CommandType.Text, strSql, param);
return result;
}
/// <summary>
/// 修改合同状态
/// </summary>
/// <param name="en"></param>
/// <returns></returns>
public int editContractState(ContractInfo en)
{
string strSql = "update ContractInfo set state=@state where contractID=@id";
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@id", en.contractID),
new SqlParameter("@state", en.state)
};
int result = SqlHelper.ExecuteNonQuery(BaseHelper.DBConnStr, CommandType.Text, strSql, param);
return result;
}
