private string Add()
{
//System.Threading.Thread.Sleep(3000);
string res = "添加成功！";
//string name = Request.Form["name"];
UserInfo user = (UserInfo)Session["user"];
Dictionary <string, string> dict = new Dictionary <string, string>();
dict.Add("code", Request.Form["code"]);
dict.Add("name", Request.Form["name"]);
dict.Add("fullName", Request.Form["fullName"]);
dict.Add("specification", Request.Form["specification"]);
if (!string.IsNullOrEmpty(Request.Form["shelfLife"]))//为空则加载默认值
{
dict.Add("shelfLife", Request.Form["shelfLife"]);
}
dict.Add("stockAccountCode", Request.Form["stockAccountCode"]);
dict.Add("salesIncomeAccountCode", Request.Form["salesIncomeAccountCode"]);
dict.Add("salesCostAccountCode", Request.Form["salesCostAccountCode"]);
if (!string.IsNullOrEmpty(Request.Form["taxRate"]))//为空则加载默认值
{
dict.Add("taxRate", Request.Form["taxRate"]);
}
dict.Add("manufacturerLicenseNumber", Request.Form["manufacturerLicenseNumber"]);
dict.Add("storageCondition", Request.Form["storageCondition"]);
dict.Add("placeOfProduction", Request.Form["placeOfProduction"]);
dict.Add("manufacturer", Request.Form["manufacturer"]);
dict.Add("productLicenseNumber", Request.Form["productLicenseNumber"]);
dict.Add("remark", Request.Form["remark"]);
dict.Add("companyId", user.companyId.ToString());
res = ProductInfoManage.InsertInfos(dict);
return(res);
}
private string getDatalist()
{
string json = "";
string type = Request.Form["type"];
string searchString = Request.Form["searchString"];
if (type == "hospital")
{
DataTable dt = OrganizationInfoManage.GetData(searchString);
if (dt != null)
{
json = JsonHelper.DataTableToJsonForEasyUiDataGridLoadDataMethod(dt.Rows.Count, dt).Trim();
}
}
else if (type == "product")
{
DataTable dt = ProductInfoManage.GetInfos(GetUserInfo().companyId.ToString(), searchString);
if (dt != null)
{
json = JsonHelper.DataTableToJsonForEasyUiDataGridLoadDataMethod(dt.Rows.Count, dt).Trim();
}
}
else if (type == "sales" || type == "supervisor" || type == "manager" || type == "director")
{
DataTable dt = UserInfoManage.getInfos(GetUserInfo().companyId.ToString(), "", searchString);
dt.Columns["userId"].ColumnName = "Id";
dt.Columns["userName"].ColumnName = "name";
if (dt != null)
{
json = JsonHelper.DataTableToJsonForEasyUiDataGridLoadDataMethod(dt.Rows.Count, dt);
}
}
return(json);
}
private string Edit()
{
string res = "添加成功！";
Dictionary <string, string> dict = new Dictionary <string, string>();
dict.Add("code", Request.Form["code"]);
dict.Add("name", Request.Form["name"]);
dict.Add("fullName", Request.Form["fullName"]);
dict.Add("specification", Request.Form["specification"]);
dict.Add("shelfLife", Request.Form["shelfLife"]);
dict.Add("stockAccountCode", Request.Form["stockAccountCode"]);
dict.Add("salesIncomeAccountCode", Request.Form["salesIncomeAccountCode"]);
dict.Add("salesCostAccountCode", Request.Form["salesCostAccountCode"]);
dict.Add("taxRate", Request.Form["taxRate"]);
dict.Add("manufacturerLicenseNumber", Request.Form["manufacturerLicenseNumber"]);
dict.Add("storageCondition", Request.Form["storageCondition"]);
dict.Add("placeOfProduction", Request.Form["placeOfProduction"]);
dict.Add("manufacturer", Request.Form["manufacturer"]);
dict.Add("productLicenseNumber", Request.Form["productLicenseNumber"]);
dict.Add("remark", Request.Form["remark"]);
string id = Request.Form["Id"];
res = ProductInfoManage.UpdateInfos(dict, id);
return(res);
}
private string destroyAliasData()
{
string json = "删除成功！";
string id = Request.Form["Id"];
ProductInfoManage.DeleteAliasData(id);
return(json);
}
private string uploadFile()
{
string res = "读取文件失败！";
DataTable dt = ExcelHelperV2_0.Import(Request);
if (dt != null)
{
res = ProductInfoManage.InsertAliasData(dt);
}
return(res);
}
private string getData(string company)
{
string json = "";
DataTable dt = ProductInfoManage.GetInfos(company, Request.Form["search"]);
if (dt != null)
{
json = JsonHelper.DataTableToJsonForEasyUiDataGridLoadDataMethod(dt.Rows.Count, dt).Trim();
}
return(json);
}
private string updateAliasData()
{
string json = "";
string code = Request.Form["productCode"];
Dictionary <string, string> dict = new Dictionary <string, string>();
dict.Add("productCode", code);
dict.Add("type", Request.Form["type"]);
dict.Add("aliasCode", Request.Form["aliasCode"]);
dict.Add("alias", Request.Form["alias"]);
ProductInfoManage.UpdateAliasData(dict, Request.Form["Id"]);
return(json);
}
private string saveAliasData()
{
string json = "";
string code = Request.Form["productCode"];
Dictionary <string, string> dict = new Dictionary <string, string>();
dict.Add("productCode", code);
dict.Add("type", Request.Form["type"]);
dict.Add("aliasCode", Request.Form["aliasCode"]);
dict.Add("alias", Request.Form["alias"]);
ProductInfoManage.InsertAliasData(dict);
//DataSet ds = ProductInfoManage.GetAliasData(code);
//if (ds != null)
// json = JsonHelper.DataTableToJsonForEasyUiDataGridLoadDataMethod(ds.Tables[0].Rows.Count, ds.Tables[0]);
return(json);
}
private string uploadFile()
{
string res = "读取文件失败！";
DataTable dt = ExcelHelperV2_0.Import(Request);
if (dt != null)
{
dt.Columns.Add("companyId");
for (int i = 0; i < dt.Rows.Count; i++)
{
dt.Rows[i]["companyId"] = GetUserInfo().companyId;
}
res = ProductInfoManage.SaveInfos(dt);
}
return(res);
}
private string getAliasData()
{
string json = "";
string code = Request.Form["code"];
if (string.IsNullOrEmpty(code))
{
code = Request.Params["code"];
}
DataSet ds = ProductInfoManage.GetAliasData(code);
if (ds != null)
{
json = JsonHelper.DataTableToJsonForEasyUiDataGridLoadDataMethod(ds.Tables[0].Rows.Count, ds.Tables[0]);
}
return(json);
}
private string getData()
{
string res = "";
string sort = Request.Form["sort"];
string order = Request.Form["order"];
DataSet ds = ProductInfoManage.GetAliasData();
if (ds != null)
{
if (string.IsNullOrEmpty(sort))
{
res = JsonHelper.DataTableToJsonForEasyUiDataGridLoadDataMethod(ds.Tables[0].Rows.Count, ds.Tables[0]);
}
else
{
DataTable dt = PinYinHelper.SortByPinYin(ds.Tables[0], sort, order);
res = JsonHelper.DataTableToJsonForEasyUiDataGridLoadDataMethod(dt.Rows.Count, dt);
}
}
return(res);
}
private string searchProduct()
{
string res = "";
string id = ((UserInfo)Session["user"]).companyId.ToString();
string search = Request.Params["searchString"];
DataTable dt = ProductInfoManage.GetInfos(id, search);
if (dt != null)
{
ArrayList list = new ArrayList();
foreach (DataRow row in dt.Rows)
{
Dictionary <string, object> dict = new Dictionary <string, object>();
dict.Add("id", row["code"]);
dict.Add("text", row["name"] + "," + row["specification"]);
list.Add(dict);
}
res = JsonHelper.SerializeObject(list);
}
return(res);
}
private string saveAlias()
{
string productCode = Request.Params["productCode"];
string pAliasName = Request.Params["pAliasName"];
string pAlisaSpecification = Request.Params["pAlisaSpecification"];
string organizationCode = Request.Params["organizationCode"];
string oAliasName = Request.Params["oAliasName"];
string type = Request.Params["type"];
string res = "";
if (!string.IsNullOrEmpty(productCode))
{
res += ProductInfoManage.SaveAliasData(productCode, pAliasName, pAlisaSpecification, type);
}
res += ",";
if (!string.IsNullOrEmpty(organizationCode))
{
res += OrganizationInfoManage.SaveAliasData(organizationCode, oAliasName, type);
}
return(res);
}
private string ValidateProductCode(string code)
{
string company = GetUserInfo().companyId.ToString();
object res = ProductInfoManage.ValidateProductCode(company, code);
if (res == null)
{
return("");
}
else
{
return(res.ToString());
}
//if(string.IsNullOrEmpty(ProductInfoManage.ValidateProductCode(company,code)))
//{
// return "T";
//}
//else
//{
// return "F";
//}
}
private string delete()
{
string ids = Request.Form["ids"];
return(ProductInfoManage.DeleteAliasData(ids));
}
private string Delete()
{
string id = Request.Form["id"];
return(ProductInfoManage.Delete(id));
}
