/// <summary>
/// 导出合同列表
/// </summary>
/// <param name="id"></param>
/// <param name="channel"></param>
/// <param name="type"></param>
/// <param name="state"></param>
/// <param name="person"></param>
/// <param name="billState"></param>
/// <param name="date"></param>
public void ContractList_output(string id, string channel, string type, string state, string person, string billState, string date)
{
DaContractInfo dal = new DaContractInfo();
DataTable dt = dal.getDataTable(id, channel, type, state, person, billState, date, BaseHelper.getCookie().id.ToString());
if (dt.Rows.Count > 0)
{
string filename = "myContractList.xls";
System.IO.StringWriter tw = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(tw);
DataGrid dgGrid = new DataGrid();
dgGrid.DataSource = dt;
dgGrid.DataBind();
//Get the HTML for the control.
dgGrid.RenderControl(hw);
//Write the HTML back to the browser.
//Response.ContentType = application/vnd.ms-excel;
Response.ContentType = "application/vnd.ms-excel";
Response.AppendHeader("Content-Disposition", "attachment; filename=" + filename + "");
Response.Write(tw.ToString());
}
else
{
Response.Write("无数据可导出！");
}
Response.End();
}
/// <summary>
/// 根据合同编号获取合同信息填充下单界面
/// </summary>
/// <param name="id">编号</param>
/// <returns></returns>
public JsonResult Order_getContract(string id)
{
DaContractInfo dal = new DaContractInfo();
ContractInfo en = dal.getEntity(id);
var result = new CustomJsonResult();
result.Data = en;
return(result);
}
/* ============ 操作 ============ */
#region 获取合同列表
/// <summary>
/// 获取合同列表
/// </summary>
/// <returns></returns>
public JsonResult Contract_getList()
{
DaContractInfo dal = new DaContractInfo();
IList <ContractInfo> contracts = dal.getList(BaseHelper.getCookie().id.ToString());
var result = new CustomJsonResult();
result.dateFormat = "yyyy-MM-dd";
result.Data = new { total = contracts.Count, rows = contracts };
return(result);
}
/// <summary>
/// 根据编号获取合同信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public JsonResult ContractList_getContract(string id)
{
DaContractInfo dal = new DaContractInfo();
ContractInfo contract = dal.getEntity(id);
var result = new CustomJsonResult();
result.dateFormat = "yyyy-MM-dd";
result.Data = contract;
return(result);
}
/// <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);
}
/// <summary>
/// 搜索合同列表
/// </summary>
/// <returns></returns>
public JsonResult ContractList_searcht(string id, string channel, string type, string state, string person, string billState, string date)
{
DaContractInfo dal = new DaContractInfo();
IList <ContractInfo> contracts = dal.getList(id, channel, type, state, person, billState, date, BaseHelper.getCookie().id.ToString());
double money = 0.0;
foreach (ContractInfo en in contracts)
{
money += en.money;
}
var result = new CustomJsonResult();
result.dateFormat = "yyyy-MM-dd";
result.Data = new { total = contracts.Count, rows = contracts, money = money };
return(result);
}
/* ============ 操作 ============ */
#region 获取合同列表
/// <summary>
/// 获取合同列表
/// </summary>
/// <returns></returns>
public JsonResult ContractList_getList()
{
DaContractInfo dal = new DaContractInfo();
IList <ContractInfo> contracts = dal.getList(BaseHelper.getCookie().id.ToString());
double money = 0.0;
foreach (ContractInfo en in contracts)
{
money += en.money;
}
var result = new CustomJsonResult();
result.dateFormat = "yyyy-MM-dd";
result.Data = new { total = contracts.Count, rows = contracts, money = money };
return(result);
}
public JsonResult Contract_add(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.add(en);
return(result);
}
