/// <summary>
/// 初始化数据
/// </summary>
/// <param name="ut"></param>
private void OnStartData(T_StorageRecordEntity ut)
{
VeriID_Input.Text = VeriID_Disp.Text = ut.VeriID.ToString();
ProjectNO_Input.Text = ProjectNO_Disp.Text = ut.ProjectNO.ToString();
EquipmentName_Input.Text = EquipmentName_Disp.Text = ut.EquipmentName.ToString();
Model_Input.Text = Model_Disp.Text = ut.Model.ToString();
StorageNumber_Input.Text = StorageNumber_Disp.Text = ut.StorageNumber.ToString();
UnitPrice_Input.Text = UnitPrice_Disp.Text = ut.UnitPrice.ToString();
StorageTime_Input.Text = StorageTime_Disp.Text = ut.StorageTime.ToString();
Applicant_Input.Text = Applicant_Disp.Text = ut.Applicant.ToString();
Approver_Input.Text = Approver_Disp.Text = ut.Approver.ToString();
PayAmount_Input.Text = PayAmount_Disp.Text = ut.PayAmount.ToString();
IntegrityCheckCode_Input.Text = IntegrityCheckCode_Disp.Text = ut.IntegrityCheckCode.ToString();
Remark_Input.Text = Remark_Disp.Text = ut.Remark.ToString();
CodeNO_Input.Text = CodeNO_Disp.Text = ut.CodeNO.ToString();
}
/// <summary>
/// 初始化数据
/// </summary>
/// <param name="ut"></param>
private void OnStartData(T_StorageRecordEntity ut)
{
StockID_Hidden.Value = ut.VeriID.ToString();
if (!string.IsNullOrEmpty(ut.CodeNO))
{
StockName_Disp.Text = "器材名称:" + ut.EquipmentName + "; 型号:" + ut.Model + ";库存编码:" + BusinessFacadeShanlitech_Location.GetCodeByStockid(ut.CodeNO);
}
EquipmentName_Hidden.Value = ut.EquipmentName;
Model_Hidden.Value = ut.Model;
CodeNO_Hidden.Value = ut.CodeNO;
//项目类别
if (!string.IsNullOrEmpty(ut.ProjectNO))
{
ListItem projectitem = ProjectNO_Input.Items.FindByValue(ut.ProjectNO.ToString());
ProjectNO_Input.ClearSelection();
if (projectitem != null)
projectitem.Selected = true;
ProjectNO_Disp.Text = BusinessFacadeShanlitech_Location.GetProjectNameByID(Convert.ToInt32(ut.ProjectNO.ToString()));
}
Approver_Disp.Text = BusinessFacadeShanlitech_Location.GetUserNameByID(ut.Approver);
//EquipmentName_Disp.Text = ut.EquipmentName;
//Model_Disp.Text = ut.Model;
//VeriID_Hidden.Value = ut.VeriID.ToString();
//VeritypeID_Hidden.Value = BusinessFacadeShanlitech_Location.T_VerificationRecordDisp(ut.VeriID).ProjID.ToString();
//if (!ut.VeriID.Equals(0))
//{
// VeriID_Disp.Text = BusinessFacadeShanlitech_Location.T_ProjectDicDisp(BusinessFacadeShanlitech_Location.T_VerificationRecordDisp(ut.VeriID).ProjID).ProjectName;
// PayAmount_Disp.Text = ut.PayAmount.ToString();
// PayAmount_Hidden.Value = ut.PayAmount.ToString();
// Applicant_Disp.Text = Applicant_Hidden.Value = ut.Applicant.ToString();
// Approver_Disp.Text = Approver_Hidden.Value = ut.Approver.ToString();
//}
//EquipmentName_Input.Text =
//EquipmentName_Disp.Text = ut.EquipmentName.ToString();
//Model_Input.Text =
//Model_Disp.Text = ut.Model.ToString();
StorageNumber_Input.Text = StorageNumber_Disp.Text = ut.StorageNumber.ToString();
UnitPrice_Input.Text = UnitPrice_Disp.Text = ut.UnitPrice.ToString();
//StorageTime_Disp.Text = ut.StorageTime.ToString();
//if (string.IsNullOrEmpty(ut.StorageTime.ToString()))
//{
// StorageTime_Disp.Text = DateTime.Now.ToString();
//}
//Applicant_Disp.Text = UserData.GetUserDate.U_LoginName;
//if (string.IsNullOrEmpty(ut.Applicant.ToString()))
//{
// Applicant_Disp.Text = BusinessFacade.sys_UserDisp(ut.Applicant).U_LoginName;
//}
Remark_Input.Text = Remark_Disp.Text = ut.Remark.ToString();
//CodeNO_Input.Text =
//CodeNO_Disp.Text = ut.CodeNO.ToString();
}
/// <summary>
/// 根据ID返回 T_StorageRecordEntity实体类 单笔资料 (入库表单)
/// </summary>
/// <param name="ID">ID ID</param>
/// <returns>返回 T_StorageRecordEntity实体类 ID为0则无记录</returns>
public static T_StorageRecordEntity T_StorageRecordDisp(Int32 ID)
{
T_StorageRecordEntity fam = new T_StorageRecordEntity();
QueryParam qp = new QueryParam();
qp.PageIndex = 1;
qp.PageSize = 1;
qp.Where = string.Format(" Where {0}.{1} = {2}", "T_StorageRecord", "ID", ID);
int RecordCount = 0;
List<T_StorageRecordEntity> lst = T_StorageRecordList(qp, out RecordCount);
if (RecordCount > 0)
{
fam = lst[0];
}
return fam;
}
/// <summary>
/// 初始化数据
/// </summary>
/// <param name="ut"></param>
private void OnStartData(T_StorageRecordEntity ut)
{
if (!string.IsNullOrEmpty(ut.CodeNO))
{
StockName_Disp.Text = "器材名称:" + ut.EquipmentName + "; 型号:" + ut.Model + ";库存编码:" + BusinessFacadeShanlitech_Location.GetCodeByStockid(ut.CodeNO);
}
//项目类别
if (!string.IsNullOrEmpty(ut.ProjectNO))
{
ProjectNO_Disp.Text = BusinessFacadeShanlitech_Location.GetProjectNameByID(Convert.ToInt32(ut.ProjectNO.ToString()));
}
//EquipmentName_Input.Text =
EquipmentName_Disp.Text = ut.EquipmentName.ToString();
//Model_Input.Text =
Model_Disp.Text = ut.Model.ToString();
//StorageNumber_Input.Text =
StorageNumber_Disp.Text = ut.StorageNumber.ToString();
//UnitPrice_Input.Text =
UnitPrice_Disp.Text = ut.UnitPrice.ToString();
StorageTime_Disp.Text = ut.StorageTime.ToString();
if (string.IsNullOrEmpty(ut.StorageTime.ToString()))
{
StorageTime_Disp.Text = DateTime.Now.ToString();
}
Applicant_Disp.Text = BusinessFacade.sys_UserDisp(ut.Applicant).U_LoginName;
Approver_Disp.Text = BusinessFacade.sys_UserDisp(ut.Approver).U_LoginName;
//Remark_Input.Text =
Remark_Disp.Text = ut.Remark.ToString();
//CodeNO_Input.Text =
CodeNO_Disp.Text = ut.CodeNO.ToString();
}
/// <summary>
/// 新增/删除/修改 T_StorageRecordEntity (入库表单)
/// </summary>
/// <param name="fam">T_StorageRecordEntity实体类</param>
/// <returns>-1:存储过程执行失败,-2:存在相同的主键,Insert:返回插入自动ID,Update:返回更新记录数,Delete:返回删除记录数</returns>
public static Int32 T_StorageRecordInsertUpdateDelete(T_StorageRecordEntity fam)
{
return DataProvider.Instance().T_StorageRecordInsertUpdateDelete(fam);
}
protected void Button2_Click(object sender, EventArgs e)
{
string Checkbox_Value = (string)Common.sink("Checkbox", MethodType.Post, 2000, 1, DataType.Str);
string[] Checkbox_Value_Array = Checkbox_Value.Split(',');
Int32 IDX = 0;
for (int i = 0; i < Checkbox_Value_Array.Length; i++)
{
if (Int32.TryParse(Checkbox_Value_Array[i], out IDX))
{
T_StorageRecordEntity et = new T_StorageRecordEntity();
et.DataTable_Action_ = DataTable_Action.Delete;
et.ID = IDX;
BusinessFacadeShanlitech_Location.T_StorageRecordInsertUpdateDelete(et);
}
}
EventMessage.MessageBox(1, "批量删除成功", string.Format("批量删除({0})成功!", Checkbox_Value), Icon_Type.OK, Common.GetHomeBaseUrl("default.aspx"));
}
/// <summary>
/// 将记录集转为T_StorageRecordEntity实体类 (入库表单)
/// </summary>
/// <param name="dr">记录集</param>
/// <param name="Fileds">字段名列表</param>
/// <returns>T_StorageRecordEntity</returns>
protected T_StorageRecordEntity PopulateT_StorageRecordEntity(IDataReader dr, Dictionary<string, string> Fileds)
{
T_StorageRecordEntity nc = new T_StorageRecordEntity();
if (Fileds.ContainsKey("ID") && !Convert.IsDBNull(dr["ID"])) nc.ID = Convert.ToInt32(dr["ID"]); // ID
if (Fileds.ContainsKey("VeriID") && !Convert.IsDBNull(dr["VeriID"])) nc.VeriID = Convert.ToInt32(dr["VeriID"]); // 所属核销
if (Fileds.ContainsKey("ProjectNO") && !Convert.IsDBNull(dr["ProjectNO"])) nc.ProjectNO = Convert.ToString(dr["ProjectNO"]).Trim(); // 所属项目
if (Fileds.ContainsKey("EquipmentName") && !Convert.IsDBNull(dr["EquipmentName"])) nc.EquipmentName = Convert.ToString(dr["EquipmentName"]).Trim(); // 器材名称
if (Fileds.ContainsKey("Model") && !Convert.IsDBNull(dr["Model"])) nc.Model = Convert.ToString(dr["Model"]).Trim(); // 型号
if (Fileds.ContainsKey("StorageNumber") && !Convert.IsDBNull(dr["StorageNumber"])) nc.StorageNumber = Convert.ToInt32(dr["StorageNumber"]); // 数量
if (Fileds.ContainsKey("UnitPrice") && !Convert.IsDBNull(dr["UnitPrice"])) nc.UnitPrice = Convert.ToDouble(dr["UnitPrice"]); // 单价
if (Fileds.ContainsKey("StorageTime") && !Convert.IsDBNull(dr["StorageTime"])) nc.StorageTime = Convert.ToDateTime(dr["StorageTime"]); // 入库时间
if (Fileds.ContainsKey("Applicant") && !Convert.IsDBNull(dr["Applicant"])) nc.Applicant = Convert.ToInt32(dr["Applicant"]); // 申请人
if (Fileds.ContainsKey("Approver") && !Convert.IsDBNull(dr["Approver"])) nc.Approver = Convert.ToInt32(dr["Approver"]); // 批准人
if (Fileds.ContainsKey("PayAmount") && !Convert.IsDBNull(dr["PayAmount"])) nc.PayAmount = Convert.ToDouble(dr["PayAmount"]); // 实际支出
if (Fileds.ContainsKey("IntegrityCheckCode") && !Convert.IsDBNull(dr["IntegrityCheckCode"])) nc.IntegrityCheckCode = Convert.ToString(dr["IntegrityCheckCode"]).Trim(); // 信息完整性校验码
if (Fileds.ContainsKey("Remark") && !Convert.IsDBNull(dr["Remark"])) nc.Remark = Convert.ToString(dr["Remark"]).Trim(); // Remark
if (Fileds.ContainsKey("CodeNO") && !Convert.IsDBNull(dr["CodeNO"])) nc.CodeNO = Convert.ToString(dr["CodeNO"]).Trim(); // 库存资产编码号
return nc;
}
/// <summary> /// 新增/删除/修改 T_StorageRecordEntity (入库表单) /// </summary> /// <param name="fam">T_StorageRecord实体类</param> /// <returns>-1:存储过程执行失败,-2:存在相同的主键,Insert:返回插入自动ID,Update:返回更新记录数,Delete:返回删除记录数</returns> public abstract Int32 T_StorageRecordInsertUpdateDelete(T_StorageRecordEntity fam);
/// <summary>
/// 初始化数据
/// </summary>
/// <param name="ut"></param>
private void OnStartData(T_StorageRecordEntity ut)
{
VeriID_Hidden.Value = ut.VeriID.ToString();
VeritypeID_Hidden.Value = BusinessFacadeShanlitech_Location.T_VerificationRecordDisp(ut.VeriID).ProjID.ToString();
if (!ut.VeriID.Equals(0))
{
VeriID_Disp.Text = BusinessFacadeShanlitech_Location.T_ProjectDicDisp(BusinessFacadeShanlitech_Location.T_VerificationRecordDisp(ut.VeriID).ProjID).ProjectName;
PayAmount_Disp.Text = ut.PayAmount.ToString();
PayAmount_Hidden.Value = ut.PayAmount.ToString();
Applicant_Disp.Text = Applicant_Hidden.Value = ut.Applicant.ToString();
Approver_Disp.Text = Approver_Hidden.Value = ut.Approver.ToString();
}
EquipmentName_Input.Text = EquipmentName_Disp.Text = ut.EquipmentName.ToString();
Model_Input.Text = Model_Disp.Text = ut.Model.ToString();
StorageNumber_Input.Text = StorageNumber_Disp.Text = ut.StorageNumber.ToString();
UnitPrice_Input.Text = UnitPrice_Disp.Text = ut.UnitPrice.ToString();
StorageTime_Disp.Text = ut.StorageTime.ToString();
if (string.IsNullOrEmpty(ut.StorageTime.ToString()))
{
StorageTime_Disp.Text = DateTime.Now.ToString();
}
Applicant_Disp.Text = UserData.GetUserDate.U_LoginName;
if (string.IsNullOrEmpty(ut.Applicant.ToString()))
{
Applicant_Disp.Text = BusinessFacade.sys_UserDisp(ut.Applicant).U_LoginName;
}
Remark_Input.Text = Remark_Disp.Text = ut.Remark.ToString();
CodeNO_Input.Text = CodeNO_Disp.Text = ut.CodeNO.ToString();
}