protected void databind()
{
E_Trade data = new E_Trade();
data.EnterpriseID = EnterpriceID;
rpList.DataSource = new T_Trade().GetList(data);
rpList.DataBind();
}
/// <summary>
/// 数据绑定
/// </summary>
protected void databind()
{
E_Trade data = new E_Trade();
data.PersonalID = PersonalID;
rpList.DataSource = new T_Trade().GetList(data);
rpList.DataBind();
}
/// <summary>
/// 分页获取列表
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public DataTable GetList(E_Trade data)
{
SqlParameter[] parameters =
{
new SqlParameter("@EnterpriseID", SqlDbType.Int)
};
parameters[0].Value = data.EnterpriseID;
return(DbHelperSQL.RunProcedureTable("ProcEP_B_Trade_ListSelect", parameters));
}
/// <summary>
/// 获取绑定显示的列表
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public DataTable GetShowList(E_Trade data)
{
SqlParameter[] parameters =
{
new SqlParameter("@EnterpriseID", SqlDbType.Int),
new SqlParameter("@CodeIsValue", SqlDbType.TinyInt)
};
parameters[0].Value = data.EnterpriseID;
parameters[1].Value = data.CodeIsValue ? 1 : 2;
return(DbHelperSQL.RunProcedureTable("ProcEP_B_Trade_ShowListSelect", parameters));
}
/// <summary>
/// 删除行业信息
/// </summary>
void TradeDelete()
{
MLMGC.Security.PersonalPage pp = new MLMGC.Security.PersonalPage(true);
int tradeid = int.Parse(nv["tradeid"]);
E_Trade data = new E_Trade();
data.PersonalID = pp.PersonalID;
data.TradeID = tradeid;
bool b = new T_Trade().Delete(data);
HttpContext.Current.Response.Write(b ? "1" : "0");
}
/// <summary>
/// 行业是否存在
/// </summary>
void TradeExists()
{
MLMGC.Security.EnterprisePage ep = new MLMGC.Security.EnterprisePage(true);
int tradeid = int.Parse(nv["tradeid"]);
string code = nv["code"];
E_Trade data = new E_Trade();
data.EnterpriseID = ep.EnterpriceID;
data.TradeID = tradeid;
data.TradeCode = code;
bool b = new T_Trade().Exists(data);
HttpContext.Current.Response.Write(b ? "1" : "0");
}
/// <summary>
/// 录入新行业
/// </summary>
void TradeAdd()
{
MLMGC.Security.PersonalPage pp = new MLMGC.Security.PersonalPage(true);
string name = nv["name"];
E_Trade data = new E_Trade();
data.PersonalID = pp.PersonalID;
data.TradeID = 0;
data.TradeCode = "";
data.TradeName = name;
int tradeid = new T_Trade().Add(data);
HttpContext.Current.Response.Write(tradeid);
}
/// <summary>
/// 行业是否存在
/// </summary>
void TradeExists()
{
MLMGC.Security.PersonalPage pp = new MLMGC.Security.PersonalPage(true);
int tradeid = int.Parse(nv["tradeid"]);
string name = nv["name"];
E_Trade data = new E_Trade();
data.PersonalID = pp.PersonalID;
data.TradeID = tradeid;
data.TradeName = name;
bool b = new T_Trade().Exists(data);
HttpContext.Current.Response.Write(b ? "1" : "0");
}
/// <summary>
/// 删除一条数据
/// </summary>
public bool Delete(E_Trade data)
{
SqlParameter[] parameters =
{
new SqlParameter("@TradeID", SqlDbType.Int, 4),
new SqlParameter("@EnterpriseID", SqlDbType.Int, 4)
};
parameters[0].Value = data.TradeID;
parameters[1].Value = data.EnterpriseID;
int ReturnValue = 0;
DbHelperSQL.RunProcedures("ProcEP_B_Trade_Delete", parameters, out ReturnValue);
return(ReturnValue > 0);
}
/// <summary>
/// 删除行业信息
/// </summary>
void TradeDelete()
{
MLMGC.Security.EnterprisePage ep = new MLMGC.Security.EnterprisePage(true);
int tradeid = int.Parse(nv["tradeid"]);
E_Trade data = new E_Trade();
data.EnterpriseID = ep.EnterpriceID;
data.TradeID = tradeid;
bool b = new T_Trade().Delete(data);
new MLMGC.BLL.Enterprise.T_Log().Add(new MLMGC.DataEntity.Enterprise.E_Log()
{
EnterpriseID = ep.EnterpriceID, UserID = ep.UserID, LogTitle = "删除行业", IP = MLMGC.COMP.Requests.GetRealIP()
});
HttpContext.Current.Response.Write(b ? "1" : "0");
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(E_Trade data)
{
int ReturnValue;
SqlParameter[] parameters =
{
new SqlParameter("@TradeID", SqlDbType.Int, 4),
new SqlParameter("@EnterpriseID", SqlDbType.Int, 4),
new SqlParameter("@TradeCode", SqlDbType.VarChar, 32)
};
parameters[0].Value = data.TradeID;
parameters[1].Value = data.EnterpriseID;
parameters[2].Value = data.TradeCode;
DbHelperSQL.RunProcedures("ProcEP_B_Trade_Exists", parameters, out ReturnValue);
return(ReturnValue > 0);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(E_Trade data)
{
SqlParameter[] parameters =
{
new SqlParameter("@TradeID", SqlDbType.Int, 4),
new SqlParameter("@EnterpriseID", SqlDbType.Int, 4),
new SqlParameter("@TradeCode", SqlDbType.VarChar, 32),
new SqlParameter("@TradeName", SqlDbType.VarChar, 128)
};
parameters[0].Value = data.TradeID;
parameters[1].Value = data.EnterpriseID;
parameters[2].Value = data.TradeCode;
parameters[3].Value = data.TradeName;
int ReturnValue = 0;
DbHelperSQL.RunProcedures("ProcEP_B_Trade_Update", parameters, out ReturnValue);
return(ReturnValue > 0);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(E_Trade data)
{
int rowsAffected;
SqlParameter[] parameters =
{
new SqlParameter("@TradeID", SqlDbType.Int, 4),
new SqlParameter("@EnterpriseID", SqlDbType.Int, 4),
new SqlParameter("@TradeCode", SqlDbType.VarChar, 32),
new SqlParameter("@TradeName", SqlDbType.VarChar, 128)
};
parameters[0].Direction = ParameterDirection.Output;
parameters[1].Value = data.EnterpriseID;
parameters[2].Value = data.TradeCode;
parameters[3].Value = data.TradeName;
DbHelperSQL.RunProcedure("ProcEP_B_Trade_Insert", parameters, out rowsAffected);
return((int)parameters[0].Value);
}
/// <summary>
/// 录入新行业
/// </summary>
void TradeAdd()
{
MLMGC.Security.EnterprisePage ep = new MLMGC.Security.EnterprisePage(true);
string code = nv["code"];
string name = nv["name"];
E_Trade data = new E_Trade();
data.EnterpriseID = ep.EnterpriceID;
data.TradeID = 0;
data.TradeCode = code;
data.TradeName = name;
int tradeid = new T_Trade().Add(data);
new MLMGC.BLL.Enterprise.T_Log().Add(new MLMGC.DataEntity.Enterprise.E_Log()
{
EnterpriseID = ep.EnterpriceID, UserID = ep.UserID, LogTitle = "添加行业", IP = MLMGC.COMP.Requests.GetRealIP()
});
HttpContext.Current.Response.Write(tradeid);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public E_Trade GetModel(E_Trade data)
{
SqlParameter[] parameters =
{
new SqlParameter("@TradeID", SqlDbType.Int, 4),
new SqlParameter("@EnterpriseID", SqlDbType.Int, 4)
};
parameters[0].Value = data.TradeID;
parameters[1].Value = data.EnterpriseID;
DataTable dt = DbHelperSQL.RunProcedureTable("ProcEP_B_Trade_Select", parameters);
if (dt != null && dt.Rows.Count == 1)
{
data.TradeCode = dt.Rows[0]["TradeCode"].ToString();
data.TradeName = dt.Rows[0]["TradeName"].ToString();
return(data);
}
return(null);
}
/// <summary>
/// 修改行业
/// </summary>
void TradeUpdate()
{
MLMGC.Security.EnterprisePage ep = new MLMGC.Security.EnterprisePage(true);
int tradeid = int.Parse(nv["tradeid"]);
string code = nv["code"];
string name = nv["name"];
E_Trade data = new E_Trade();
data.EnterpriseID = ep.EnterpriceID;
data.TradeID = tradeid;
data.TradeCode = code;
data.TradeName = name;
bool b = new T_Trade().Update(data);
new MLMGC.BLL.Enterprise.T_Log().Add(new MLMGC.DataEntity.Enterprise.E_Log()
{
EnterpriseID = ep.EnterpriceID, UserID = ep.UserID, LogTitle = "修改行业", IP = MLMGC.COMP.Requests.GetRealIP()
});
HttpContext.Current.Response.Write(b ? "1" : "0");
}
/// <summary>
/// 显示行业信息
/// </summary>
void TradeShow()
{
MLMGC.Security.EnterprisePage ep = new MLMGC.Security.EnterprisePage(true);
int tradeid = int.Parse(nv["tradeid"]);
E_Trade data = new E_Trade();
data.EnterpriseID = ep.EnterpriceID;
data.TradeID = tradeid;
data = new T_Trade().GetModel(data);
if (data == null)
{
data = new E_Trade();
data.TradeID = 0;
}
JsonObjectCollection colDR = new JsonObjectCollection();
colDR.Add(new JsonStringValue("id", data.TradeID.ToString()));
colDR.Add(new JsonStringValue("code", data.TradeCode));
colDR.Add(new JsonStringValue("name", data.TradeName));
HttpContext.Current.Response.Write(colDR.ToString());
}
/// <summary>
/// 获取绑定显示的列表
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public DataTable GetShowList(E_Trade data)
{
return(dal.GetShowList(data));
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public E_Trade GetModel(E_Trade data)
{
return(dal.GetModel(data));
}
/// <summary>
/// 删除一条数据
/// </summary>
public bool Delete(E_Trade data)
{
return(dal.Delete(data));
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(E_Trade data)
{
return(dal.Update(data));
}
/// <summary>
/// 批量增加行业
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
/// <remarks>qipengfei 2011-10-25</remarks>
public bool BatchAdd(E_Trade data)
{
return(dal.BatchAdd(data));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(E_Trade data)
{
return(dal.Add(data));
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(E_Trade data)
{
return(dal.Exists(data));
}
