/// <summary>
/// 更新一条数据
/// </summary>
public void UpdateFeesSubjectInfo(FeesSubjectInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tbFeesSubjectInfo set ");
strSql.Append("fName=@fName,");
strSql.Append("fAppendTime=@fAppendTime,");
strSql.Append("FeesSubjectClassID=@FeesSubjectClassID,");
strSql.Append("fCode=@fCode,");
strSql.Append("fDebitCredit=@fDebitCredit");
strSql.Append(" where FeesSubjectID=@FeesSubjectID ");
SqlParameter[] parameters =
{
new SqlParameter("@FeesSubjectID", SqlDbType.Int, 4),
new SqlParameter("@fName", SqlDbType.VarChar, 50),
new SqlParameter("@fAppendTime", SqlDbType.DateTime),
new SqlParameter("@FeesSubjectClassID", SqlDbType.Int, 4),
new SqlParameter("@fCode", SqlDbType.VarChar, 50),
new SqlParameter("@fDebitCredit", SqlDbType.Int, 4),
};
parameters[0].Value = model.FeesSubjectID;
parameters[1].Value = model.fName;
parameters[2].Value = model.fAppendTime;
parameters[3].Value = model.FeesSubjectClassID;
parameters[4].Value = model.fCode;
parameters[5].Value = model.fDebitCredit;
DbHelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), parameters);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int AddFeesSubjectInfo(FeesSubjectInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tbFeesSubjectInfo(");
strSql.Append("fName,fAppendTime,FeesSubjectClassID,fCode,fDebitCredit)");
strSql.Append(" values (");
strSql.Append("@fName,@fAppendTime,@FeesSubjectClassID,@fCode,@fDebitCredit)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@fName", SqlDbType.VarChar, 50),
new SqlParameter("@fAppendTime", SqlDbType.DateTime),
new SqlParameter("@FeesSubjectClassID", SqlDbType.Int, 4),
new SqlParameter("@fCode", SqlDbType.VarChar, 50),
new SqlParameter("@fDebitCredit", SqlDbType.Int, 4),
};
parameters[0].Value = model.fName;
parameters[1].Value = model.fAppendTime;
parameters[2].Value = model.FeesSubjectClassID;
parameters[3].Value = model.fCode;
parameters[4].Value = model.fDebitCredit;
object obj = DbHelper.ExecuteScalar(CommandType.Text, strSql.ToString(), parameters);
if (obj == null)
{
return(1);
}
else
{
return(Convert.ToInt32(obj));
}
}
protected virtual void Page_Load(object sender, EventArgs e)
{
Act = HTTPRequest.GetString("Act");
if (Act.Trim() == "")
{
StoresID = HTTPRequest.GetInt("StoresID", 0);
}
else if (Act == "com")
{
Feeid = HTTPRequest.GetInt("Feeid", 0);
}
try
{
bDate = DateTime.Parse(HTTPRequest.GetString("bDate") + " 00:00:00");
eDate = DateTime.Parse(HTTPRequest.GetString("eDate") + " 23:59:59");
if (StoresID > 0)
{
si = tbStoresInfo.GetStoresInfoModel(StoresID);
dList = DataUtils.Get_Fees_by_StoresID(bDate, eDate, StoresID);
if (dList != null)
{
foreach (DataRow dr in dList.Rows)
{
AllSumValue += Convert.ToDecimal(dr["mFees"]);
}
}
}
if (Feeid > 0)
{
fs = tbFeesSubjectInfo.GetFeesSubjectInfoModel(Feeid);
dList = DataUtils.Get_Fees_by_FeesSubjectID(bDate, eDate, Feeid);
if (dList != null)
{
foreach (DataRow dr in dList.Rows)
{
AllSumValue += Convert.ToDecimal(dr["mFees"]);
}
}
}
if (StoresID <= 0 && Feeid <= 0)
{
AddErrLine("参数错误!");
}
}
catch (Exception ex) {
AddErrLine("参数错误!" + ex.Message);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public FeesSubjectInfo GetFeesSubjectInfoModelByName(string fName)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 FeesSubjectID,fName,fAppendTime,FeesSubjectClassID,fCode,fDebitCredit from tbFeesSubjectInfo ");
strSql.Append(" where fName=@fName ");
SqlParameter[] parameters =
{
new SqlParameter("@fName", SqlDbType.VarChar, 50)
};
parameters[0].Value = fName;
FeesSubjectInfo model = new FeesSubjectInfo();
DataSet ds = DbHelper.ExecuteDataset(CommandType.Text, strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["FeesSubjectID"].ToString() != "")
{
model.FeesSubjectID = int.Parse(ds.Tables[0].Rows[0]["FeesSubjectID"].ToString());
}
if (ds.Tables[0].Rows[0]["FeesSubjectClassID"].ToString() != "")
{
model.FeesSubjectClassID = int.Parse(ds.Tables[0].Rows[0]["FeesSubjectClassID"].ToString());
}
if (ds.Tables[0].Rows[0]["fDebitCredit"].ToString() != "")
{
model.fDebitCredit = int.Parse(ds.Tables[0].Rows[0]["fDebitCredit"].ToString());
}
model.fCode = ds.Tables[0].Rows[0]["fCode"].ToString();
model.fName = ds.Tables[0].Rows[0]["fName"].ToString();
if (ds.Tables[0].Rows[0]["fAppendTime"].ToString() != "")
{
model.fAppendTime = DateTime.Parse(ds.Tables[0].Rows[0]["fAppendTime"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public static void UpdateFeesSubjectInfo(FeesSubjectInfo model)
{
DatabaseProvider.GetInstance().UpdateFeesSubjectInfo(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public static int AddFeesSubjectInfo(FeesSubjectInfo model)
{
return(DatabaseProvider.GetInstance().AddFeesSubjectInfo(model));
}
protected virtual void Page_Load(object sender, EventArgs e)
{
if (this.userid > 0)
{
if (CheckUserPopedoms("X") || CheckUserPopedoms("1"))
{
Act = HTTPRequest.GetString("Act");
FeesSubjectClass = Caches.GetFeesSubjectClassInfoToHTML();
fName = Utils.ChkSQL(HTTPRequest.GetString("fName"));
FeesSubjectClassID = HTTPRequest.GetInt("FeesSubjectClassID", 0);
fCode = Utils.ChkSQL(HTTPRequest.GetString("fCode"));
fDebitCredit = HTTPRequest.GetInt("fDebitCredit", 0);
if (Act == "Edit")
{
FeesSubjectID = Utils.StrToInt(HTTPRequest.GetString("fid"), 0);
FeesSubject = tbFeesSubjectInfo.GetFeesSubjectInfoModel(FeesSubjectID);
}
if (ispost)
{
FeesSubject.FeesSubjectClassID = FeesSubjectClassID;
FeesSubject.fCode = fCode;
FeesSubject.fDebitCredit = fDebitCredit;
if (Act == "Add")
{
if (!tbFeesSubjectInfo.ExistsFeesSubjectInfo(fName))
{
FeesSubject.fName = fName;
FeesSubject.fAppendTime = fAppendTime;
if (tbFeesSubjectInfo.AddFeesSubjectInfo(FeesSubject) > 0)
{
AddMsgLine("创建成功!");
AddScript("window.setTimeout('window.parent.HidBox();',1000);");
}
else
{
AddErrLine("创建失败!");
AddScript("window.setTimeout('history.back(1);',1000);");
}
}
else
{
AddErrLine("费用科目:" + fName + ",已存在,请更换!");
AddScript("window.setTimeout('history.back(1);',1000);");
}
}
if (Act == "Edit")
{
if (FeesSubjectID > 0)
{
if (!tbFeesSubjectInfo.ExistsFeesSubjectInfo(fName) || FeesSubject.fName == fName)
{
FeesSubject.fName = fName;
try
{
tbFeesSubjectInfo.UpdateFeesSubjectInfo(FeesSubject);
AddMsgLine("修改成功!");
AddScript("window.setTimeout('window.parent.HidBox();',1000);");
}
catch (Exception ex)
{
AddErrLine("修改失败!<br/>" + ex);
AddScript("window.setTimeout('window.parent.HidBox();',1000);");
}
}
else
{
AddErrLine("费用科目:" + fName + ",已存在,请更换!");
AddScript("window.setTimeout('history.back(1);',1000);");
}
}
else
{
AddErrLine("参数错误,修改失败!");
AddScript("window.setTimeout('window.parent.HidBox();',1000);");
}
}
}
else
{
if (Act == "Add")
{
FeesSubject.fName = "";
}
if (Act == "Del")
{
try
{
tbFeesSubjectInfo.DeleteFeesSubjectInfo(HTTPRequest.GetString("fid"));
AddMsgLine("删除成功!");
AddScript("window.setTimeout('window.parent.HidBox();',1000);");
}
catch (Exception ex)
{
AddErrLine("删除失败!<br/>" + ex);
AddScript("window.setTimeout('window.parent.HidBox();',1000);");
}
}
}
}
else
{
AddErrLine("权限不足!");
AddScript("window.setTimeout('window.parent.HidBox();',1000);");
}
}
else
{
AddErrLine("请先登录!");
SetBackLink("login.aspx?referer=" + Utils.UrlEncode(Utils.GetUrlReferrer()));
SetMetaRefresh(1, "login.aspx?referer=" + Utils.UrlEncode(Utils.GetUrlReferrer()));
}
}
protected virtual void Page_Load(object sender, EventArgs e)
{
if (this.userid > 0)
{
if (CheckUserPopedoms("X") || CheckUserPopedoms("6-1"))
{
if (ispost)
{
int sType = Utils.StrToInt(HTTPRequest.GetString("sType"), 0);
string PathStr = Utils.GetMapPath(config.DataPath.ToString());
string fileExtension = "";
string fileName = "";
string thispath = DateTime.Now.Year + "-" + DateTime.Now.Month;
ArrayList filearr = new ArrayList();
int importdata_count = 0;
if (!Directory.Exists(PathStr + thispath))
{
Directory.CreateDirectory(PathStr + thispath);
}
//文件上传
HttpFileCollection files = HttpContext.Current.Request.Files;
try
{
if (files.Count > 0)
{
for (int i = 0; i < files.Count; i++)
{
HttpPostedFile postedFile = files[i];
fileName = System.IO.Path.GetFileName(postedFile.FileName);
if (Utils.ChkSQL(fileName) != "")
{
fileExtension = System.IO.Path.GetExtension(fileName).ToLower();
if (fileExtension == ".xls")
{
postedFile.SaveAs(PathStr + thispath + "/" + fileName);
filearr.Add(PathStr + thispath + "/" + fileName);
}
}
}
}
if (filearr.Count > 0)
{
MarketingFeesInfo mi = new MarketingFeesInfo();
StoresInfo si = new StoresInfo();
FeesSubjectInfo fi = new FeesSubjectInfo();
StaffInfo ft = new StaffInfo();
try
{
for (int j = 0; j < filearr.Count; j++)
{
try
{
DataSet ds = Excels.ExcelToDataTable(filearr[j].ToString());
DataTable dt = new DataTable();
try
{
dt = ds.Tables[0];
foreach (DataRow dr in dt.Rows)
{
mi.mAppendTime = DateTime.Now;
if (sType == 0)//营销费用
{
if (dr[0].ToString() != "" && dr[1].ToString() != "" && dr[2].ToString() != "" && dr[3].ToString() != "" && dr[4].ToString() != "")
{
if (Utils.IsNumeric(dr[3].ToString()))
{
si = tbStoresInfo.GetStoresInfoModelByName(dr[2].ToString().Trim());
if (si == null)
{
si = tbStoresInfo.GetStoresInfoModelByCode(dr[1].ToString().Trim());
}
if (si != null)
{
mi.StoresID = si.StoresID;
}
fi = tbFeesSubjectInfo.GetFeesSubjectInfoModelByName(dr[4].ToString().Trim());
if (fi != null)
{
mi.FeesSubjectID = fi.FeesSubjectID;
}
mi.mRemark = dr[5].ToString().Trim();
mi.mFees = decimal.Parse(Utils.StrToFloat(dr[3].ToString().Trim(), 0).ToString());
mi.mDateTime = DateTime.Parse(dr[0].ToString().Trim());
mi.mType = 0;
mi.StaffID = 0;
if (tbMarketingFeesInfo.AddMarketingFeesInfo(mi) > 0)
{
importdata_count++;
}
}
}
}
if (sType == 1)//公司费用
{
if (dr[0].ToString() != "" && dr[1].ToString() != "" && dr[2].ToString() != "" && dr[3].ToString() != "")
{
if (Utils.IsNumeric(dr[2].ToString()))
{
mi.StoresID = 0;
mi.mDateTime = DateTime.Parse(dr[0].ToString().Trim());
fi = tbFeesSubjectInfo.GetFeesSubjectInfoModelByName(dr[1].ToString().Trim());
if (fi != null)
{
mi.FeesSubjectID = fi.FeesSubjectID;
}
mi.mFees = decimal.Parse(Utils.StrToFloat(dr[2].ToString().Trim(), 0).ToString());
ft = tbStaffInfo.GetStaffInfoModelByName(dr[3].ToString().Trim());
if (ft != null)
{
mi.StaffID = ft.StaffID;
}
mi.mType = 1;
mi.mRemark = dr[4].ToString().Trim();
if (tbMarketingFeesInfo.AddMarketingFeesInfo(mi) > 0)
{
importdata_count++;
}
}
}
}
if (sType == 2)//收入
{
if (dr[0].ToString() != "" && dr[1].ToString() != "" && dr[2].ToString() != "")
{
if (Utils.IsNumeric(dr[1].ToString()))
{
mi.StoresID = 0;
mi.mDateTime = DateTime.Parse(dr[0].ToString().Trim());
if (dr[3].ToString().Trim() != "")
{
fi = tbFeesSubjectInfo.GetFeesSubjectInfoModelByName(dr[3].ToString().Trim());
if (fi != null)
{
mi.FeesSubjectID = fi.FeesSubjectID;
}
}
else
{
mi.FeesSubjectID = 0;
}
mi.mFees = decimal.Parse(Utils.StrToFloat(dr[1].ToString().Trim(), 0).ToString());
ft = tbStaffInfo.GetStaffInfoModelByName(dr[2].ToString().Trim());
if (ft != null)
{
mi.StaffID = ft.StaffID;
}
mi.mIsIncomeExpenditure = 1;
mi.mType = -1;
mi.mRemark = dr[4].ToString().Trim();
if (tbMarketingFeesInfo.AddMarketingFeesInfo(mi) > 0)
{
importdata_count++;
}
}
}
}
}
}
finally
{
ds.Clear();
ds.Dispose();
}
}
catch (Exception ex)
{
AddErrLine("<b>文件格式错误,请将 Xls 文件用 Excel 另存后再导入!</b>:<br>" + ex);
//AddScript("window.setTimeout('history.back(1);',5000);");
}
}
if (importdata_count > 0)
{
AddMsgLine("数据导入成功!共导入数据[" + importdata_count.ToString() + "]条.");
AddScript("window.setTimeout('window.parent.HidBox();',5000);");
}
else
{
AddErrLine("系统忙!导入失败!");
//AddScript("window.setTimeout('history.back(1);',1000);");
}
}
finally
{
mi = null;
si = null;
ft = null;
}
}
else
{
AddErrLine("为发现任何数据!导入失败!");
AddScript("window.setTimeout('history.back(1);',1000);");
}
}
finally
{
files = null;
filearr.Clear();
}
}
}
else
{
AddErrLine("权限不足!");
AddScript("window.setTimeout('window.parent.HidBox();',1000);");
}
}
else
{
AddErrLine("请先登录!");
SetBackLink("login.aspx?referer=" + Utils.UrlEncode(Utils.GetUrlReferrer()));
SetMetaRefresh(1, "login.aspx?referer=" + Utils.UrlEncode(Utils.GetUrlReferrer()));
}
}
