protected void bSaveAccountablePerson_Click(object sender, EventArgs e)
{
try
{
AccountablePersonData apd = fillFromForm();
if (gvAccountablePersons.Rows.Count > 0)
{
int id = Convert.ToInt32(gvAccountablePersons.DataKeys[gvAccountablePersons.SelectedIndex].Values["id"]);
AccountablePersonData apds = db.getAccountablePersonData(id);
for (int i = 0; i < apd.accountdata.Length; i++)
{
AccountablePersonAccountData apad = apds.accountdata.FirstOrDefault(r => r.id > 0 && r.product_type_enum == apd.accountdata[i].product_type_enum &&
r.account_type_enum == apd.accountdata[i].account_type_enum &&
r.issafe == apd.accountdata[i].issafe);
if (apad != null)
{
apd.accountdata[i].id = apad.id;
}
}
apd.id = id;
}
int idBranch = sc.BranchId(Page.User.Identity.Name);
db.saveAccountablePersonData(apd, idBranch);
RefreshList(gvAccountablePersons.SelectedIndex);
selectID();
}
catch (Exception e1)
{
ClientScript.RegisterClientScriptBlock(GetType(), "bSave_ReClick", "<script type='text/javascript'>$(document).ready(function(){ " +
"clickEdit(); ShowError('" + System.Security.SecurityElement.Escape(e1.Message) + "'); });</script>");
}
}
public AccountablePersonData getAccountablePersonData(int id, SqlTransaction trans = null)
{
AccountablePersonData apd = new AccountablePersonData();
if (id != 0)
{
SqlCommand cmdSelect = new SqlCommand(string.Format("select a.*, UserName, b.id as UserId from AccountablePerson a left join aspnet_Users b on a.UserId=b.id where a.id = {0}", id), conn);
cmdSelect.Transaction = trans;
using (SqlDataReader dr = cmdSelect.ExecuteReader())
{
if (dr.HasRows)
{
dr.Read();
apd.id = Convert.ToInt32(dr["id"]);
apd.secondname = (string)dr["secondname"];
apd.firstname = (string)dr["firstname"];
if (dr["patronymic"] != DBNull.Value)
{
apd.patronymic = (string)dr["patronymic"];
}
if (dr["birthday"] != DBNull.Value)
{
apd.birthday = Convert.ToDateTime(dr["birthday"]);
}
if (dr["position"] != DBNull.Value)
{
apd.position = (string)dr["position"];
}
if (dr["passport"] != DBNull.Value)
{
apd.passport = (string)dr["passport"];
}
if (dr["dateissue"] != DBNull.Value)
{
apd.dateissue = Convert.ToDateTime(dr["dateissue"]);
}
if (dr["issuedby"] != DBNull.Value)
{
apd.issuedby = (string)dr["issuedby"];
}
if (dr["UserName"] != DBNull.Value)
{
apd.userLogin = (string)dr["UserName"];
}
if (dr["UserId"] != DBNull.Value)
{
apd.userId = (int)dr["UserId"];
}
apd.personnelnumber = (string)dr["personnelnumber"];
apd.active = Convert.ToBoolean(dr["active"]);
}
else
{
throw new Exception("getAccountablePersonData: запись с идентификатором " + id.ToString() + " не найдена");
}
}
cmdSelect = new SqlCommand(string.Format("select * from AccountablePersonAccount where id_accountableperson = {0}", apd.id), conn);
using (SqlDataReader dr = cmdSelect.ExecuteReader())
{
if (dr.HasRows)
{
while (dr.Read() == true)
{
AccountablePersonAccountData apad = apd.accountdata.FirstOrDefault(r => r.product_type_enum == Convert.ToInt32(dr["product_type_enum"]) &&
r.account_type_enum == Convert.ToInt32(dr["account_type_enum"]) &&
r.issafe == Convert.ToBoolean(dr["issafe"]));
if (apad != null)
{
apad.id = Convert.ToInt32(dr["id"]);
apad.id_accountableperson = Convert.ToInt32(dr["id_accountableperson"]);
apad.account_debet = (string)dr["account_debet"];
apad.account_credit = (string)dr["account_credit"];
}
}
}
}
}
return(apd);
}
protected TextBox getControlCredit(AccountablePersonAccountData aData)
{
return(getControl(null, getDefaultName(aData) + "_Credit"));
}
protected string getDefaultName(AccountablePersonAccountData aData)
{
return(((BaseProductType)(aData.product_type_enum)).ToString() + "_" + ((AccountBranchType)(aData.account_type_enum)).ToString() + "_" + aData.issafe.ToString());
}
public AccountablePersonData()
{
accountdata = new AccountablePersonAccountData[(Enum.GetNames(typeof(BaseProductType)).Length - 1) * COUNTOPERATION];
secondname = "";
firstname = "";
patronymic = "";
birthday = DateTime.MinValue;
position = "";
passport = "";
dateissue = DateTime.MinValue;
issuedby = "";
personnelnumber = "";
active = true;
userLogin = "";
userId = 0;
foreach (var value in Enum.GetValues(typeof(BaseProductType)))
{
if ((int)value == 0)
{
continue;
}
int index = ((int)value) - 1;
for (int i = 0; i < COUNTOPERATION; i++)
{
accountdata[index * COUNTOPERATION + i] = new AccountablePersonAccountData();
AccountablePersonAccountData ad = accountdata[index * COUNTOPERATION + i];
ad.product_type_enum = (int)value;
if (i < 2)
{
if (i == 1)
{
ad.account_credit = ACCOUNTSAFE;
ad.issafe = true;
}
else
{
ad.account_credit = ACCOUNTSTORAGE;
ad.issafe = false;
}
ad.account_debet = "91203???????????????";
ad.account_type_enum = (int)AccountBranchType.In;
}
if (i == 2)
{
ad.account_credit = "91203???????????????";
ad.account_debet = ACCOUNTCLIENT;
ad.issafe = false;
ad.account_type_enum = (int)AccountBranchType.Out;
}
if (i > 2 && i < 5)
{
if (i == 4)
{
ad.account_debet = ACCOUNTSAFE;
ad.issafe = true;
}
else
{
ad.account_debet = ACCOUNTSTORAGE;
ad.issafe = false;
}
ad.account_credit = "91203???????????????";
ad.account_type_enum = (int)AccountBranchType.Return;
}
}
}
}
