/// <summary>
/// 获取现金推算表信息
/// </summary>
/// <returns></returns>
public DataTable GetCashStatisticInfoOneYear(ListCafeEntity model)
{
string strHtml = " from T_Cash t1,T_Items t2,DirAndMin t3 where t1.ItemsId=t2.ItemsId and t1.Operators=t3.Minister and " +
" t3.Director='" + model.UserCode.Trim() + "' and t2.ItemsType=28 and t2.IsVisible=1 ";
if (model.YearS == 0)
{
strHtml += " and cYear=datename(yyyy,getdate()) ";
}
else
{
strHtml += " and cYear=" + model.YearS;
}
DataTable dt = new DataTable();
string strSql = "select t1.ItemsId,ItemsName,cYear,MONTH(getdate()) NowMonth,datename(yyyy,getdate()) NowYear," +
"SUM(JanPlan) JanPlan,SUM(FebPlan) FebPlan,SUM(MarPlan) MarPlan,SUM(AprPlan) AprPlan,SUM(MayPlan) MayPlan,SUM(JunPlan) JunPlan," +
"SUM(JulPlan) JulPlan,SUM(AugPlan) AugPlan,SUM(SepPlan) SepPlan,SUM(OctPlan) OctPlan,SUM(NovPlan) NovPlan,SUM(DecPlan) DecPlan " +
strHtml.Trim() + " group by t1.ItemsId,ItemsName,cYear order by t1.ItemsId ";
try
{
db.Open();
dt = db.GetDataTableWithSQL(strSql);
}
catch
{
dt = null;
}
finally
{
db.Close();
}
return(dt);
}
/// <summary>
/// 获取现金推算表信息
/// </summary>
/// <returns></returns>
public DataTable GetCashInfoOneYear(ListCafeEntity model)
{
string strHtml = " from T_Cash t1,T_Items t2 where t1.ItemsId=t2.ItemsId and t1.Operators='" + model.UserCode.Trim() + "' and t2.ItemsType=28 and t2.IsVisible=1 ";
if (model.YearS == 0)
{
strHtml += " and cYear=datename(yyyy,getdate()) ";
}
else
{
strHtml += " and cYear=" + model.YearS;
}
DataTable dt = new DataTable();
string strSql = "select t1.Id,t1.ItemsId,ItemsName,cYear,MONTH(getdate()) NowMonth,datename(yyyy,getdate()) NowYear," +
"JanPlan,FebPlan,MarPlan,AprPlan,MayPlan,JunPlan,JulPlan,AugPlan,SepPlan,OctPlan,NovPlan,DecPlan " + strHtml.Trim();
try
{
db.Open();
dt = db.GetDataTableWithSQL(strSql);
}
catch
{
dt = null;
}
finally
{
db.Close();
}
return(dt);
}
/// <summary>
/// 获取现金推算表信息
/// </summary>
/// <returns></returns>
public DataTable GetCashInfoTwoYear(ListCafeEntity model)
{
DataTable dt = new DataTable();
string strSql = "select t4.ItemsName,t3.*from (select t1.*,t2.* from (select Id,ItemsId,cYear,MONTH(getdate()) NowMonth,datename(yyyy,getdate()) NowYear," +
"JanPlan,FebPlan,MarPlan,AprPlan,MayPlan,JunPlan,JulPlan,AugPlan,SepPlan,OctPlan,NovPlan,DecPlan " +
"from T_Cash where Operators='" + model.UserCode.Trim() + "' and cYear=" + model.YearS + ") t1," +
"(select Id kId,ItemsId kItemsId,cYear kcYear," +
"JanPlan kJanPlan,FebPlan kFebPlan,MarPlan kMarPlan,AprPlan kAprPlan,MayPlan kMayPlan,JunPlan kJunPlan,JulPlan kJulPlan,AugPlan kAugPlan," +
"SepPlan kSepPlan,OctPlan kOctPlan,NovPlan kNovPlan,DecPlan kDecPlan " +
"from T_Cash where Operators='" + model.UserCode.Trim() + "' and cYear=" + model.YearE + ") t2 where t1.ItemsId=t2.kItemsId) t3,T_Items t4 where t3.ItemsId=t4.ItemsId and t4.ItemsType=28 and t4.IsVisible=1";
try
{
db.Open();
dt = db.GetDataTableWithSQL(strSql);
}
catch
{
dt = null;
}
finally
{
db.Close();
}
return(dt);
}
public DataSet ChangeCafeRest(ListCafeEntity entity)
{
DataSet ds = new DataSet("SHOPXML");
ds.Tables.Add(dalcommon.ChangeCafeRest(entity));
return(ds);
}
/// <summary>
/// 获取现金推算表信息
/// </summary>
/// <returns></returns>
public DataTable GetCashStatisticInfoAllTwoYear(ListCafeEntity model)
{
DataTable dt = new DataTable();
string strSql = "select t4.ItemsName,t3.*from (select t1.*,t2.* from (select ItemsId,cYear,MONTH(getdate()) NowMonth,datename(yyyy,getdate()) NowYear," +
"SUM(JanPlan) JanPlan,SUM(FebPlan) FebPlan,SUM(MarPlan) MarPlan,SUM(AprPlan) AprPlan,SUM(MayPlan) MayPlan,SUM(JunPlan) JunPlan," +
"SUM(JulPlan) JulPlan,SUM(AugPlan) AugPlan,SUM(SepPlan) SepPlan,SUM(OctPlan) OctPlan,SUM(NovPlan) NovPlan,SUM(DecPlan) DecPlan " +
"from T_Cash where cYear=" + model.YearS + " group by ItemsId,cYear) t1," +
"(select ItemsId kItemsId,cYear kcYear," +
"SUM(JanPlan) kJanPlan,SUM(FebPlan) kFebPlan,SUM(MarPlan) kMarPlan,SUM(AprPlan) kAprPlan,SUM(MayPlan) kMayPlan,SUM(JunPlan) kJunPlan," +
"SUM(JulPlan) kJulPlan,SUM(AugPlan) kAugPlan,SUM(SepPlan) kSepPlan,SUM(OctPlan) kOctPlan,SUM(NovPlan) kNovPlan,SUM(DecPlan) kDecPlan " +
"from T_Cash where cYear=" + model.YearE + " group by ItemsId,cYear) t2 " +
"where t1.ItemsId=t2.kItemsId) t3,T_Items t4 where t3.ItemsId=t4.ItemsId and t4.ItemsType=28 and t4.IsVisible=1 order by t3.ItemsId";
try
{
db.Open();
dt = db.GetDataTableWithSQL(strSql);
}
catch
{
dt = null;
}
finally
{
db.Close();
}
return(dt);
}
//修改阶段目标往后列
public DataTable ChangeCafeRest(ListCafeEntity entity)
{
string sql = " UPDATE T_CafeChase SET OriPlan=case TheMonth when 1 then '" + entity.oriPlan + "'when 2 then '" + entity.oriPlan2 + "' when 3 then '" + entity.oriPlan3 + "' when 4 then '" + entity.oriPlan4 + "' when 5 then '" + entity.oriPlan5 + "' when 6 then '" + entity.oriPlan6 + "' when 7 then '" + entity.oriPlan7 + "' when 8 then '" + entity.oriPlan8 + "' when 9 then '" + entity.oriPlan9 + "' when 10 then '" + entity.oriPlan10 + "' when 11 then '" + entity.oriPlan11 + "' else '" + entity.oriPlan12 + "' end, " +
"Balance1=case TheMonth when 1 then '" + entity.balance + "'when 2 then '" + entity.balance2 + "' when 3 then '" + entity.balance3 + "' when 4 then '" + entity.balance4 + "' when 5 then '" + entity.balance5 + "' when 6 then '" + entity.balance6 + "' when 7 then '" + entity.balance7 + "' when 8 then '" + entity.balance8 + "' when 9 then '" + entity.balance9 + "' when 10 then '" + entity.balance10 + "' when 11 then '" + entity.balance11 + "' else '" + entity.balance12 + "'end," +
"Adjusted=case TheMonth when 1 then '" + entity.adjutsted + "'when 2 then '" + entity.adjutsted2 + "' when 3 then '" + entity.adjutsted3 + "' when 4 then '" + entity.adjutsted4 + "' when 5 then '" + entity.adjutsted5 + "' when 6 then '" + entity.adjutsted6 + "' when 7 then '" + entity.adjutsted7 + "' when 8 then '" + entity.adjutsted8 + "' when 9 then '" + entity.adjutsted9 + "' when 10 then '" + entity.adjutsted10 + "' when 11 then '" + entity.adjutsted11 + "' else '" + entity.adjutsted12 + "'end," +
"Balance2=case TheMonth when 1 then '" + entity.balanceT + "'when 2 then '" + entity.balanceT2 + "' when 3 then '" + entity.balanceT3 + "' when 4 then '" + entity.balanceT4 + "' when 5 then '" + entity.balanceT5 + "' when 6 then '" + entity.balanceT6 + "' when 7 then '" + entity.balanceT7 + "' when 8 then '" + entity.balanceT8 + "' when 9 then '" + entity.balanceT9 + "' when 10 then '" + entity.balanceT10 + "' when 11 then '" + entity.balanceT11 + "' else '" + entity.balanceT12 + "'end" +
" where TheMonth in (1,2,3,4,5,6,7,8,9,10,11,12) and cYear='" + entity.year + "' and Operators='" + entity.mname + "'";
try
{
db.Open();
dt = db.GetDataTableWithSQL(sql.ToString());
}
catch
{
dt = null;
}
finally
{
db.Close();
}
return(dt);
}
/// <summary>
/// 获取咖啡追赶表信息
/// </summary>
/// <returns></returns>
public DataTable GetCafeChaseInfoTwoYear(ListCafeEntity model)
{
DataTable dt = new DataTable();
string strSql = "select t1.*,t2.* from (SELECT Id,LaAllYear,LastMonthPlan,Adjust,dbo.GetRollYear(cYear,TheMonth) RollYear,StageGoal,OriPlan,Balance1,Balance2," +
"dbo.GetBalance1(Operators,cYear,TheMonth) BType1,Adjusted,dbo.GetBalance2(Operators,cYear,TheMonth) BType2,isnull(Measure,'') Measure," +
"right('00'+convert(varchar(5),TheMonth),2) TheMonth,cYear,MONTH(getdate()) NowMonth,datename(yyyy,getdate()) NowYear,cYear_Target, " +
"(select sum(LaAllYear) FROM T_CafeChase where Operators='" + model.UserCode.Trim() + "' and cYear=" + model.YearS + ") sum1, " +
"(select sum(LastMonthPlan) FROM T_CafeChase where Operators='" + model.UserCode.Trim() + "' and cYear=" + model.YearS + ") sum2, " +
"(select sum(Adjust) FROM T_CafeChase where Operators='" + model.UserCode.Trim() + "' and cYear=" + model.YearS + ") sum3 " +
"FROM T_CafeChase where Operators='" + model.UserCode.Trim() + "' and cYear=" + model.YearS + ") t1," +
"(SELECT Id kId,LaAllYear kLaAllYear,LastMonthPlan kLastMonthPlan,Adjust kAdjust,dbo.GetRollYear(cYear,TheMonth) kRollYear,StageGoal kStageGoal,OriPlan kOriPlan,Balance1 kBalance1,Balance2 kBalance2," +
"dbo.GetBalance1(Operators,cYear,TheMonth) kBType1,Adjusted kAdjusted,dbo.GetBalance2(Operators,cYear,TheMonth) kBType2,isnull(Measure,'') kMeasure," +
"right('00'+convert(varchar(5),TheMonth),2) kTheMonth,cYear kcYear,cYear_Target kcYear_Target, " +
"(select sum(LaAllYear) FROM T_CafeChase where Operators='" + model.UserCode.Trim() + "' and cYear=" + model.YearE + ") ksum1, " +
"(select sum(LastMonthPlan) FROM T_CafeChase where Operators='" + model.UserCode.Trim() + "' and cYear=" + model.YearE + ") ksum2, " +
"(select sum(Adjust) FROM T_CafeChase where Operators='" + model.UserCode.Trim() + "' and cYear=" + model.YearE + ") ksum3 " +
"FROM T_CafeChase where Operators='" + model.UserCode.Trim() + "' and cYear=" + model.YearE + ") t2 where t1.TheMonth=t2.kTheMonth";
try
{
db.Open();
dt = db.GetDataTableWithSQL(strSql);
}
catch
{
dt = null;
}
finally
{
db.Close();
}
return(dt);
}
/// <summary>
/// 保存现金推算表信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int SaleCafeInfoOneYear(ListCafeEntity model)
{
SqlParameter[] parameters =
{
new SqlParameter("vJanPlan", SqlDbType.VarChar, 800),
new SqlParameter("vFebPlan", SqlDbType.VarChar, 800),
new SqlParameter("vMarPlan", SqlDbType.VarChar, 800),
new SqlParameter("vAprPlan", SqlDbType.VarChar, 800),
new SqlParameter("vMayPlan", SqlDbType.VarChar, 800),
new SqlParameter("vJunPlan", SqlDbType.VarChar, 800),
new SqlParameter("vJulPlan", SqlDbType.VarChar, 800),
new SqlParameter("vAugPlan", SqlDbType.VarChar, 800),
new SqlParameter("vSepPlan", SqlDbType.VarChar, 800),
new SqlParameter("vOctPlan", SqlDbType.VarChar, 800),
new SqlParameter("vNovPlan", SqlDbType.VarChar, 800),
new SqlParameter("vDecPlan", SqlDbType.VarChar, 800),
new SqlParameter("vsId", SqlDbType.VarChar, 800),
new SqlParameter("vOperators", SqlDbType.VarChar, 50),
new SqlParameter("vYearS", SqlDbType.Int),
new SqlParameter("vYearE", SqlDbType.Int)
};
parameters[0].Value = model.JanPlan;
parameters[1].Value = model.FebPlan;
parameters[2].Value = model.MarPlan;
parameters[3].Value = model.AprPlan;
parameters[4].Value = model.MayPlan;
parameters[5].Value = model.JunPlan;
parameters[6].Value = model.JulPlan;
parameters[7].Value = model.AugPlan;
parameters[8].Value = model.SepPlan;
parameters[9].Value = model.OctPlan;
parameters[10].Value = model.NovPlan;
parameters[11].Value = model.DecPlan;
parameters[12].Value = model.sId;
parameters[13].Value = model.Operators;
parameters[14].Value = model.YearS;
parameters[15].Value = model.YearE;
string commandText = "SaleCafeInfoOneYear";
int result = 0;
try
{
db.Open();
db.ExecuteNonQuery(commandText, CommandType.StoredProcedure, parameters);
result = 1;
}
catch //(InvalidOperationException ex)
{
result = 0;
}
finally
{
db.Close();
}
return(result);
}
/// <summary>
/// 保存咖啡追赶表信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int SaleCafeChaseInfoTwoYear(ListCafeEntity model)
{
SqlParameter[] parameters =
{
new SqlParameter("vOperators", SqlDbType.VarChar, 50),
new SqlParameter("vYearS", SqlDbType.Int),
new SqlParameter("vYearE", SqlDbType.Int),
new SqlParameter("vMeasure", SqlDbType.VarChar, 800),
new SqlParameter("vcYear_Target", SqlDbType.Int),
new SqlParameter("vsId", SqlDbType.VarChar, 800),
new SqlParameter("vkMeasure", SqlDbType.VarChar, 800),
new SqlParameter("vkcYear_Target", SqlDbType.Int),
new SqlParameter("vkId", SqlDbType.VarChar, 800)
};
parameters[0].Value = model.Operators;
parameters[1].Value = model.YearS;
parameters[2].Value = model.YearE;
parameters[3].Value = model.Measure;
parameters[4].Value = model.cYear_Target;
parameters[5].Value = model.sId;
parameters[6].Value = model.kMeasure;
parameters[7].Value = model.kcYear_Target;
parameters[8].Value = model.ksId;
string commandText = "SaleCafeChaseInfoTwoYear";
int result = 0;
try
{
db.Open();
db.ExecuteNonQuery(commandText, CommandType.StoredProcedure, parameters);
result = 1;
}
catch //(InvalidOperationException ex)
{
result = 0;
}
finally
{
db.Close();
}
return(result);
}
//修改阶段目标
public DataTable ChangeStageGoal(ListCafeEntity entity)
{
string sql = " UPDATE T_CafeChase SET cYear_Target='" + entity.yearGoal + "', StageGoal=case TheMonth when 1 then '" + entity.sGoal + "'when 2 then '" + entity.sGoal2 + "' when 3 then '" + entity.sGoal3 + "' when 4 then '" + entity.sGoal4 + "' when 5 then '" + entity.sGoal5 + "' when 6 then '" + entity.sGoal6 + "' when 7 then '" + entity.sGoal7 + "' when 8 then '" + entity.sGoal8 + "' when 9 then '" + entity.sGoal9 + "' when 10 then '" + entity.sGoal10 + "' when 11 then '" + entity.sGoal11 + "' else '" + entity.sGoal12 + "' end where TheMonth in (1,2,3,4,5,6,7,8,9,10,11,12) and cYear='" + entity.year + "' and Operators='" + entity.mname + "'";
try
{
db.Open();
dt = db.GetDataTableWithSQL(sql.ToString());
}
catch
{
dt = null;
}
finally
{
db.Close();
}
return(dt);
}
/// <summary>
/// 获取咖啡追赶表信息
/// </summary>
/// <returns></returns>
public DataSet GetCafeChaseInfo(ListCafeEntity model)
{
DataSet ds = new DataSet("SHOPXML");
if (model.YearS == 0 || model.YearE == 0)
{
ds.Tables.Add(dalcommon.GetCafeChaseInfoOneYear(model));
}
else
{
if ((Convert.ToInt32(model.YearS) == Convert.ToInt32(model.YearE)))
{
ds.Tables.Add(dalcommon.GetCafeChaseInfoOneYear(model));
}
else
{
ds.Tables.Add(dalcommon.GetCafeChaseInfoTwoYear(model));
}
}
return(ds);
}
/// <summary>
/// 获取现金推算表信息
/// </summary>
/// <returns></returns>
public DataSet GetCashStatisticInfoAll(ListCafeEntity model)
{
DataSet ds = new DataSet("SHOPXML");
//if (model.YearS == 0 || model.YearE == 0)
//{
// ds.Tables.Add(dalCash.GetCashStatisticInfoAllOneYear(model));
//}
//else
//{
// if ((Convert.ToInt32(model.YearS) == Convert.ToInt32(model.YearE)))
// {
// ds.Tables.Add(dalCash.GetCashStatisticInfoAllOneYear(model));
// }
// else
// {
ds.Tables.Add(dalCash.GetCashStatisticInfoAllTwoYear(model));
// }
//}
return(ds);
}
/// <summary>
/// 获取咖啡追赶表信息
/// </summary>
/// <returns></returns>
public DataTable GetCafeChaseInfoOneYear(ListCafeEntity model)
{
string strHtml = "";
DataTable dt = new DataTable();
if (model.YearS == 0)
{
strHtml = " and cYear=datename(yyyy,getdate()) ";
}
else
{
strHtml = " and cYear=" + model.YearS;
}
string strSql = "SELECT Id,LaAllYear,LastMonthPlan,Adjust,dbo.GetRollYear(cYear,TheMonth) RollYear,StageGoal,OriPlan,Balance1,Balance2," +
"dbo.GetBalance1(Operators,cYear,TheMonth) BType1,Adjusted,dbo.GetBalance2(Operators,cYear,TheMonth) BType2," +
"Measure,right('00'+convert(varchar(5),TheMonth),2) TheMonth,cYear,MONTH(getdate()) NowMonth,datename(yyyy,getdate()) NowYear,cYear_Target, " +
"(select sum(LaAllYear) FROM T_CafeChase where Operators='" + model.UserCode.Trim() + "' " + strHtml.Trim() + ") sum1, " +
"(select sum(LastMonthPlan) FROM T_CafeChase where Operators='" + model.UserCode.Trim() + "' " + strHtml.Trim() + ") sum2, " +
"(select sum(Adjust) FROM T_CafeChase where Operators='" + model.UserCode.Trim() + "' " + strHtml.Trim() + ") sum3 " +
"FROM T_CafeChase where Operators='" + model.UserCode.Trim() + "' " + strHtml.Trim();
try
{
db.Open();
dt = db.GetDataTableWithSQL(strSql);
}
catch
{
dt = null;
}
finally
{
db.Close();
}
return(dt);
}
private void GetExcelData(DataTable dt)
{
string MM = DateTime.Now.ToString("MM");
ListCafeEntity entity = new ListCafeEntity();
Cash BllCash = new Cash();
for (int i = 1; i < dt.Rows.Count; i++)
{
if (MM == "01")
{
entity.JanPlan = dt.Rows[i][1].ToString().Trim();
entity.FebPlan = dt.Rows[i][2].ToString().Trim();
entity.MarPlan = dt.Rows[i][3].ToString().Trim();
entity.AprPlan = dt.Rows[i][4].ToString().Trim();
entity.MayPlan = dt.Rows[i][5].ToString().Trim();
entity.JunPlan = dt.Rows[i][6].ToString().Trim();
entity.JulPlan = dt.Rows[i][7].ToString().Trim();
entity.AugPlan = dt.Rows[i][8].ToString().Trim();
entity.SepPlan = dt.Rows[i][9].ToString().Trim();
entity.OctPlan = dt.Rows[i][10].ToString().Trim();
entity.NovPlan = dt.Rows[i][11].ToString().Trim();
entity.DecPlan = dt.Rows[i][12].ToString().Trim();
entity.kJanPlan = dt.Rows[i][13].ToString().Trim();
entity.kFebPlan = dt.Rows[i][14].ToString().Trim();
entity.kMarPlan = dt.Rows[i][15].ToString().Trim();
entity.kAprPlan = dt.Rows[i][16].ToString().Trim();
entity.kMayPlan = dt.Rows[i][17].ToString().Trim();
entity.kJunPlan = dt.Rows[i][18].ToString().Trim();
entity.kJulPlan = dt.Rows[i][19].ToString().Trim();
entity.kAugPlan = dt.Rows[i][20].ToString().Trim();
entity.kSepPlan = dt.Rows[i][21].ToString().Trim();
entity.kOctPlan = dt.Rows[i][22].ToString().Trim();
entity.kNovPlan = dt.Rows[i][23].ToString().Trim();
entity.kDecPlan = dt.Rows[i][24].ToString().Trim();
}
else if (MM == "02")
{
entity.JanPlan = dt.Rows[i][1].ToString().Trim();
entity.FebPlan = dt.Rows[i][2].ToString().Trim();
entity.MarPlan = dt.Rows[i][3].ToString().Trim();
entity.AprPlan = dt.Rows[i][4].ToString().Trim();
entity.MayPlan = dt.Rows[i][5].ToString().Trim();
entity.JunPlan = dt.Rows[i][6].ToString().Trim();
entity.JulPlan = dt.Rows[i][7].ToString().Trim();
entity.AugPlan = dt.Rows[i][8].ToString().Trim();
entity.SepPlan = dt.Rows[i][9].ToString().Trim();
entity.OctPlan = dt.Rows[i][10].ToString().Trim();
entity.NovPlan = dt.Rows[i][11].ToString().Trim();
entity.DecPlan = dt.Rows[i][12].ToString().Trim();
entity.kJanPlan = dt.Rows[i][13].ToString().Trim();
entity.kFebPlan = dt.Rows[i][14].ToString().Trim();
entity.kMarPlan = dt.Rows[i][15].ToString().Trim();
entity.kAprPlan = dt.Rows[i][16].ToString().Trim();
entity.kMayPlan = dt.Rows[i][17].ToString().Trim();
entity.kJunPlan = dt.Rows[i][18].ToString().Trim();
entity.kJulPlan = dt.Rows[i][19].ToString().Trim();
entity.kAugPlan = dt.Rows[i][20].ToString().Trim();
entity.kSepPlan = dt.Rows[i][21].ToString().Trim();
entity.kOctPlan = dt.Rows[i][22].ToString().Trim();
entity.kNovPlan = dt.Rows[i][23].ToString().Trim();
entity.kDecPlan = dt.Rows[i][24].ToString().Trim();
}
else if (MM == "03")
{
entity.FebPlan = dt.Rows[i][1].ToString().Trim();
entity.MarPlan = dt.Rows[i][2].ToString().Trim();
entity.AprPlan = dt.Rows[i][3].ToString().Trim();
entity.MayPlan = dt.Rows[i][4].ToString().Trim();
entity.JunPlan = dt.Rows[i][5].ToString().Trim();
entity.JulPlan = dt.Rows[i][6].ToString().Trim();
entity.AugPlan = dt.Rows[i][7].ToString().Trim();
entity.SepPlan = dt.Rows[i][8].ToString().Trim();
entity.OctPlan = dt.Rows[i][9].ToString().Trim();
entity.NovPlan = dt.Rows[i][10].ToString().Trim();
entity.DecPlan = dt.Rows[i][11].ToString().Trim();
entity.kJanPlan = dt.Rows[i][12].ToString().Trim();
entity.kFebPlan = dt.Rows[i][13].ToString().Trim();
entity.kMarPlan = dt.Rows[i][14].ToString().Trim();
entity.kAprPlan = dt.Rows[i][15].ToString().Trim();
entity.kMayPlan = dt.Rows[i][16].ToString().Trim();
entity.kJunPlan = dt.Rows[i][17].ToString().Trim();
entity.kJulPlan = dt.Rows[i][18].ToString().Trim();
entity.kAugPlan = dt.Rows[i][19].ToString().Trim();
entity.kSepPlan = dt.Rows[i][20].ToString().Trim();
entity.kOctPlan = dt.Rows[i][21].ToString().Trim();
entity.kNovPlan = dt.Rows[i][22].ToString().Trim();
entity.kDecPlan = dt.Rows[i][23].ToString().Trim();
}
else if (MM == "04")
{
entity.MarPlan = dt.Rows[i][1].ToString().Trim();
entity.AprPlan = dt.Rows[i][2].ToString().Trim();
entity.MayPlan = dt.Rows[i][3].ToString().Trim();
entity.JunPlan = dt.Rows[i][4].ToString().Trim();
entity.JulPlan = dt.Rows[i][5].ToString().Trim();
entity.AugPlan = dt.Rows[i][6].ToString().Trim();
entity.SepPlan = dt.Rows[i][7].ToString().Trim();
entity.OctPlan = dt.Rows[i][8].ToString().Trim();
entity.NovPlan = dt.Rows[i][9].ToString().Trim();
entity.DecPlan = dt.Rows[i][10].ToString().Trim();
entity.kJanPlan = dt.Rows[i][11].ToString().Trim();
entity.kFebPlan = dt.Rows[i][12].ToString().Trim();
entity.kMarPlan = dt.Rows[i][13].ToString().Trim();
entity.kAprPlan = dt.Rows[i][14].ToString().Trim();
entity.kMayPlan = dt.Rows[i][15].ToString().Trim();
entity.kJunPlan = dt.Rows[i][16].ToString().Trim();
entity.kJulPlan = dt.Rows[i][17].ToString().Trim();
entity.kAugPlan = dt.Rows[i][18].ToString().Trim();
entity.kSepPlan = dt.Rows[i][19].ToString().Trim();
entity.kOctPlan = dt.Rows[i][20].ToString().Trim();
entity.kNovPlan = dt.Rows[i][21].ToString().Trim();
entity.kDecPlan = dt.Rows[i][22].ToString().Trim();
}
else if (MM == "05")
{
entity.AprPlan = dt.Rows[i][1].ToString().Trim();
entity.MayPlan = dt.Rows[i][2].ToString().Trim();
entity.JunPlan = dt.Rows[i][3].ToString().Trim();
entity.JulPlan = dt.Rows[i][4].ToString().Trim();
entity.AugPlan = dt.Rows[i][5].ToString().Trim();
entity.SepPlan = dt.Rows[i][6].ToString().Trim();
entity.OctPlan = dt.Rows[i][7].ToString().Trim();
entity.NovPlan = dt.Rows[i][8].ToString().Trim();
entity.DecPlan = dt.Rows[i][9].ToString().Trim();
entity.kJanPlan = dt.Rows[i][10].ToString().Trim();
entity.kFebPlan = dt.Rows[i][11].ToString().Trim();
entity.kMarPlan = dt.Rows[i][12].ToString().Trim();
entity.kAprPlan = dt.Rows[i][13].ToString().Trim();
entity.kMayPlan = dt.Rows[i][14].ToString().Trim();
entity.kJunPlan = dt.Rows[i][15].ToString().Trim();
entity.kJulPlan = dt.Rows[i][16].ToString().Trim();
entity.kAugPlan = dt.Rows[i][17].ToString().Trim();
entity.kSepPlan = dt.Rows[i][18].ToString().Trim();
entity.kOctPlan = dt.Rows[i][19].ToString().Trim();
entity.kNovPlan = dt.Rows[i][20].ToString().Trim();
entity.kDecPlan = dt.Rows[i][21].ToString().Trim();
}
else if (MM == "06")
{
entity.MayPlan = dt.Rows[i][1].ToString().Trim();
entity.JunPlan = dt.Rows[i][2].ToString().Trim();
entity.JulPlan = dt.Rows[i][3].ToString().Trim();
entity.AugPlan = dt.Rows[i][4].ToString().Trim();
entity.SepPlan = dt.Rows[i][5].ToString().Trim();
entity.OctPlan = dt.Rows[i][6].ToString().Trim();
entity.NovPlan = dt.Rows[i][7].ToString().Trim();
entity.DecPlan = dt.Rows[i][8].ToString().Trim();
entity.kJanPlan = dt.Rows[i][9].ToString().Trim();
entity.kFebPlan = dt.Rows[i][10].ToString().Trim();
entity.kMarPlan = dt.Rows[i][11].ToString().Trim();
entity.kAprPlan = dt.Rows[i][12].ToString().Trim();
entity.kMayPlan = dt.Rows[i][13].ToString().Trim();
entity.kJunPlan = dt.Rows[i][14].ToString().Trim();
entity.kJulPlan = dt.Rows[i][15].ToString().Trim();
entity.kAugPlan = dt.Rows[i][16].ToString().Trim();
entity.kSepPlan = dt.Rows[i][17].ToString().Trim();
entity.kOctPlan = dt.Rows[i][18].ToString().Trim();
entity.kNovPlan = dt.Rows[i][19].ToString().Trim();
entity.kDecPlan = dt.Rows[i][20].ToString().Trim();
}
else if (MM == "07")
{
entity.JunPlan = dt.Rows[i][1].ToString().Trim();
entity.JulPlan = dt.Rows[i][2].ToString().Trim();
entity.AugPlan = dt.Rows[i][3].ToString().Trim();
entity.SepPlan = dt.Rows[i][4].ToString().Trim();
entity.OctPlan = dt.Rows[i][5].ToString().Trim();
entity.NovPlan = dt.Rows[i][6].ToString().Trim();
entity.DecPlan = dt.Rows[i][7].ToString().Trim();
entity.kJanPlan = dt.Rows[i][8].ToString().Trim();
entity.kFebPlan = dt.Rows[i][9].ToString().Trim();
entity.kMarPlan = dt.Rows[i][10].ToString().Trim();
entity.kAprPlan = dt.Rows[i][11].ToString().Trim();
entity.kMayPlan = dt.Rows[i][12].ToString().Trim();
entity.kJunPlan = dt.Rows[i][13].ToString().Trim();
entity.kJulPlan = dt.Rows[i][14].ToString().Trim();
entity.kAugPlan = dt.Rows[i][15].ToString().Trim();
entity.kSepPlan = dt.Rows[i][16].ToString().Trim();
entity.kOctPlan = dt.Rows[i][17].ToString().Trim();
entity.kNovPlan = dt.Rows[i][18].ToString().Trim();
entity.kDecPlan = dt.Rows[i][19].ToString().Trim();
}
else if (MM == "08")
{
entity.JulPlan = dt.Rows[i][1].ToString().Trim();
entity.AugPlan = dt.Rows[i][2].ToString().Trim();
entity.SepPlan = dt.Rows[i][3].ToString().Trim();
entity.OctPlan = dt.Rows[i][4].ToString().Trim();
entity.NovPlan = dt.Rows[i][5].ToString().Trim();
entity.DecPlan = dt.Rows[i][6].ToString().Trim();
entity.kJanPlan = dt.Rows[i][7].ToString().Trim();
entity.kFebPlan = dt.Rows[i][8].ToString().Trim();
entity.kMarPlan = dt.Rows[i][9].ToString().Trim();
entity.kAprPlan = dt.Rows[i][10].ToString().Trim();
entity.kMayPlan = dt.Rows[i][11].ToString().Trim();
entity.kJunPlan = dt.Rows[i][12].ToString().Trim();
entity.kJulPlan = dt.Rows[i][13].ToString().Trim();
entity.kAugPlan = dt.Rows[i][14].ToString().Trim();
entity.kSepPlan = dt.Rows[i][15].ToString().Trim();
entity.kOctPlan = dt.Rows[i][16].ToString().Trim();
entity.kNovPlan = dt.Rows[i][17].ToString().Trim();
entity.kDecPlan = dt.Rows[i][18].ToString().Trim();
}
else if (MM == "09")
{
entity.AugPlan = dt.Rows[i][1].ToString().Trim();
entity.SepPlan = dt.Rows[i][2].ToString().Trim();
entity.OctPlan = dt.Rows[i][3].ToString().Trim();
entity.NovPlan = dt.Rows[i][4].ToString().Trim();
entity.DecPlan = dt.Rows[i][5].ToString().Trim();
entity.kJanPlan = dt.Rows[i][6].ToString().Trim();
entity.kFebPlan = dt.Rows[i][7].ToString().Trim();
entity.kMarPlan = dt.Rows[i][8].ToString().Trim();
entity.kAprPlan = dt.Rows[i][9].ToString().Trim();
entity.kMayPlan = dt.Rows[i][10].ToString().Trim();
entity.kJunPlan = dt.Rows[i][11].ToString().Trim();
entity.kJulPlan = dt.Rows[i][12].ToString().Trim();
entity.kAugPlan = dt.Rows[i][13].ToString().Trim();
entity.kSepPlan = dt.Rows[i][14].ToString().Trim();
entity.kOctPlan = dt.Rows[i][15].ToString().Trim();
entity.kNovPlan = dt.Rows[i][16].ToString().Trim();
entity.kDecPlan = dt.Rows[i][17].ToString().Trim();
}
else if (MM == "10")
{
entity.SepPlan = dt.Rows[i][1].ToString().Trim();
entity.OctPlan = dt.Rows[i][2].ToString().Trim();
entity.NovPlan = dt.Rows[i][3].ToString().Trim();
entity.DecPlan = dt.Rows[i][4].ToString().Trim();
entity.kJanPlan = dt.Rows[i][5].ToString().Trim();
entity.kFebPlan = dt.Rows[i][6].ToString().Trim();
entity.kMarPlan = dt.Rows[i][7].ToString().Trim();
entity.kAprPlan = dt.Rows[i][8].ToString().Trim();
entity.kMayPlan = dt.Rows[i][9].ToString().Trim();
entity.kJunPlan = dt.Rows[i][10].ToString().Trim();
entity.kJulPlan = dt.Rows[i][11].ToString().Trim();
entity.kAugPlan = dt.Rows[i][12].ToString().Trim();
entity.kSepPlan = dt.Rows[i][13].ToString().Trim();
entity.kOctPlan = dt.Rows[i][14].ToString().Trim();
entity.kNovPlan = dt.Rows[i][15].ToString().Trim();
entity.kDecPlan = dt.Rows[i][16].ToString().Trim();
}
else if (MM == "11")
{
entity.OctPlan = dt.Rows[i][1].ToString().Trim();
entity.NovPlan = dt.Rows[i][2].ToString().Trim();
entity.DecPlan = dt.Rows[i][3].ToString().Trim();
entity.kJanPlan = dt.Rows[i][4].ToString().Trim();
entity.kFebPlan = dt.Rows[i][5].ToString().Trim();
entity.kMarPlan = dt.Rows[i][6].ToString().Trim();
entity.kAprPlan = dt.Rows[i][7].ToString().Trim();
entity.kMayPlan = dt.Rows[i][8].ToString().Trim();
entity.kJunPlan = dt.Rows[i][9].ToString().Trim();
entity.kJulPlan = dt.Rows[i][10].ToString().Trim();
entity.kAugPlan = dt.Rows[i][11].ToString().Trim();
entity.kSepPlan = dt.Rows[i][12].ToString().Trim();
entity.kOctPlan = dt.Rows[i][13].ToString().Trim();
entity.kNovPlan = dt.Rows[i][14].ToString().Trim();
entity.kDecPlan = dt.Rows[i][15].ToString().Trim();
}
else if (MM == "12")
{
entity.NovPlan = dt.Rows[i][1].ToString().Trim();
entity.DecPlan = dt.Rows[i][2].ToString().Trim();
entity.kJanPlan = dt.Rows[i][3].ToString().Trim();
entity.kFebPlan = dt.Rows[i][4].ToString().Trim();
entity.kMarPlan = dt.Rows[i][5].ToString().Trim();
entity.kAprPlan = dt.Rows[i][6].ToString().Trim();
entity.kMayPlan = dt.Rows[i][7].ToString().Trim();
entity.kJunPlan = dt.Rows[i][8].ToString().Trim();
entity.kJulPlan = dt.Rows[i][9].ToString().Trim();
entity.kAugPlan = dt.Rows[i][10].ToString().Trim();
entity.kSepPlan = dt.Rows[i][11].ToString().Trim();
entity.kOctPlan = dt.Rows[i][12].ToString().Trim();
entity.kNovPlan = dt.Rows[i][13].ToString().Trim();
entity.kDecPlan = dt.Rows[i][14].ToString().Trim();
}
entity.Title = dt.Rows[i][0].ToString().Trim();
entity.Operators = this.strOp.Value;
uploadMsg.Text = " 正在上传，请勿关闭窗口！！！ ";
int state = BllCash.ImportCash(entity);
if (state != 1)
{
return;
}
}
uploadMsg.Text = "<script language='javascript'>hiddenDiv('divAdd');</script>";
}
/// <summary>
/// 导入现金推算表信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int ImportCash(ListCafeEntity model)
{
return(dalCash.ImportCash(model));
}
/// <summary>
/// 保存咖啡追赶表信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int SaleCafeChaseInfoTwoYear(ListCafeEntity model)
{
return(dalcommon.SaleCafeChaseInfoTwoYear(model));
}
/// <summary>
/// 导入现金推算表信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int ImportCash(ListCafeEntity model)
{
SqlParameter[] parameters =
{
new SqlParameter("vJanPlan", SqlDbType.VarChar, 50),
new SqlParameter("vFebPlan", SqlDbType.VarChar, 50),
new SqlParameter("vMarPlan", SqlDbType.VarChar, 50),
new SqlParameter("vAprPlan", SqlDbType.VarChar, 50),
new SqlParameter("vMayPlan", SqlDbType.VarChar, 50),
new SqlParameter("vJunPlan", SqlDbType.VarChar, 50),
new SqlParameter("vJulPlan", SqlDbType.VarChar, 50),
new SqlParameter("vAugPlan", SqlDbType.VarChar, 50),
new SqlParameter("vSepPlan", SqlDbType.VarChar, 50),
new SqlParameter("vOctPlan", SqlDbType.VarChar, 50),
new SqlParameter("vNovPlan", SqlDbType.VarChar, 50),
new SqlParameter("vDecPlan", SqlDbType.VarChar, 50),
new SqlParameter("vkJanPlan", SqlDbType.VarChar, 50),
new SqlParameter("vkFebPlan", SqlDbType.VarChar, 50),
new SqlParameter("vkMarPlan", SqlDbType.VarChar, 50),
new SqlParameter("vkAprPlan", SqlDbType.VarChar, 50),
new SqlParameter("vkMayPlan", SqlDbType.VarChar, 50),
new SqlParameter("vkJunPlan", SqlDbType.VarChar, 50),
new SqlParameter("vkJulPlan", SqlDbType.VarChar, 50),
new SqlParameter("vkAugPlan", SqlDbType.VarChar, 50),
new SqlParameter("vkSepPlan", SqlDbType.VarChar, 50),
new SqlParameter("vkOctPlan", SqlDbType.VarChar, 50),
new SqlParameter("vkNovPlan", SqlDbType.VarChar, 50),
new SqlParameter("vkDecPlan", SqlDbType.VarChar, 50),
new SqlParameter("vOperators", SqlDbType.VarChar, 50),
new SqlParameter("vTitle", SqlDbType.VarChar, 50)
};
parameters[0].Value = model.JanPlan == null ? "0" : model.JanPlan;
parameters[1].Value = model.FebPlan == null ? "0" : model.FebPlan;
parameters[2].Value = model.MarPlan == null ? "0" : model.MarPlan;
parameters[3].Value = model.AprPlan == null ? "0" : model.AprPlan;
parameters[4].Value = model.MayPlan == null ? "0" : model.MayPlan;
parameters[5].Value = model.JunPlan == null ? "0" : model.JunPlan;
parameters[6].Value = model.JulPlan == null ? "0" : model.JulPlan;
parameters[7].Value = model.AugPlan == null ? "0" : model.AugPlan;
parameters[8].Value = model.SepPlan == null ? "0" : model.SepPlan;
parameters[9].Value = model.OctPlan == null ? "0" : model.OctPlan;
parameters[10].Value = model.NovPlan == null ? "0" : model.NovPlan;
parameters[11].Value = model.DecPlan == null ? "0" : model.DecPlan;
parameters[12].Value = model.kJanPlan;
parameters[13].Value = model.kFebPlan;
parameters[14].Value = model.kMarPlan;
parameters[15].Value = model.kAprPlan;
parameters[16].Value = model.kMayPlan;
parameters[17].Value = model.kJunPlan;
parameters[18].Value = model.kJulPlan;
parameters[19].Value = model.kAugPlan;
parameters[20].Value = model.kSepPlan;
parameters[21].Value = model.kOctPlan;
parameters[22].Value = model.kNovPlan;
parameters[23].Value = model.kDecPlan;
parameters[24].Value = model.Operators;
parameters[25].Value = model.Title;
string commandText = "ImportCash";
int result = 0;
try
{
db.Open();
db.ExecuteNonQuery(commandText, CommandType.StoredProcedure, parameters);
result = 1;
}
catch //(InvalidOperationException ex)
{
result = 0;
}
finally
{
db.Close();
}
return(result);
}
/// <summary>
/// 保存现金推算表信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int SaleCafeInfoTwoYear(ListCafeEntity model)
{
return(dalCash.SaleCafeInfoTwoYear(model));
}
