/// <summary>
/// 增加一条数据
/// </summary>
public string Add(基础设置.Model.客户协议登记表_业务员 model)
{
StringBuilder strSql = new StringBuilder();
StringBuilder strSql1 = new StringBuilder();
StringBuilder strSql2 = new StringBuilder();
if (model.GUID != null)
{
strSql1.Append("GUID,");
strSql2.Append("'" + model.GUID + "',");
}
if (model.cPersonCode != null)
{
strSql1.Append("cPersonCode,");
strSql2.Append("'" + model.cPersonCode + "',");
}
if (model.StartDate != null && model.StartDate > Convert.ToDateTime("1900-01-01"))
{
strSql1.Append("StartDate,");
strSql2.Append("'" + model.StartDate + "',");
}
if (model.ENDDate != null && model.ENDDate > Convert.ToDateTime("1900-01-01"))
{
strSql1.Append("ENDDate,");
strSql2.Append("'" + model.ENDDate + "',");
}
if (model.Remark != null)
{
strSql1.Append("Remark,");
strSql2.Append("'" + model.Remark + "',");
}
strSql.Append("insert into 客户协议登记表_业务员(");
strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1));
strSql.Append(")");
strSql.Append(" values (");
strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1));
strSql.Append(")");
strSql.Append(";select @@IDENTITY");
return(strSql.ToString());
}
/// <summary>
/// 保存
/// </summary>
private void btnSave()
{
try
{
try
{
gridView1.FocusedRowHandle -= 1;
gridView1.FocusedRowHandle += 1;
gridView2.FocusedRowHandle -= 1;
gridView2.FocusedRowHandle += 1;
}
catch { }
if (lookUpEditYear.Text.Trim() == "")
{
lookUpEditYear.Focus();
throw new Exception("请设置年度");
}
if (lookUpEdit代理商.EditValue == null || lookUpEdit代理商.Text.Trim() == "")
{
btnTxtDLS.Focus();
throw new Exception("请选择代理商");
}
string s代理商编码 = lookUpEdit代理商.EditValue.ToString().Trim();
//DateTime dtm1 = dateEdit1.DateTime;
//DateTime dtm2 = dateEdit2.DateTime;
string s返点方式 = lookUpEdit返点方式.Text.Trim();
if (s返点方式 == "")
{
lookUpEdit返点方式.Focus();
throw new Exception("请选择返点方式");
}
string sErr = "";
aList = new System.Collections.ArrayList();
bool b = false;
Guid sGuid = Guid.NewGuid();
sSQL = @"
select GUID from 客户协议登记表 where iYear = aaaaaaaa and 代理商 = 'bbbbbbbb'
";
sSQL = sSQL.Replace("aaaaaaaa", lookUpEditYear.Text.Trim());
sSQL = sSQL.Replace("bbbbbbbb", s代理商编码);
DataTable dtGuid = clsSQLCommond.ExecQuery(sSQL);
if (dtGuid != null && dtGuid.Rows.Count > 0)
{
if (dtGuid.Rows[0]["GUID"].ToString().Trim() != "")
{
sGuid = (Guid)dtGuid.Rows[0]["GUID"];
}
}
sSQL = @"
delete 客户协议登记表 where iYear = aaaaaaaa and 代理商 = 'bbbbbbbb'
";
sSQL = sSQL.Replace("aaaaaaaa", lookUpEditYear.Text.Trim());
sSQL = sSQL.Replace("bbbbbbbb", s代理商编码);
aList.Add(sSQL);
for (int i = 0; i < gridView1.RowCount; i++)
{
Model.客户协议登记表 mod = new 基础设置.Model.客户协议登记表();
string s编码 = gridView1.GetRowCellValue(i, gridCol编码).ToString().Trim();
if (s编码 == "")
{
continue;
}
sSQL = @"
select count(1)
from U8Inventory
where cInvCode = 'aaaaaaaa'
";
sSQL = sSQL.Replace("aaaaaaaa", s编码);
DataTable dt = clsSQLCommond.ExecQuery(sSQL);
if (dt == null || dt.Rows.Count == 0)
{
sErr = sErr + "行 " + (i + 1).ToString() + " 品种不存在\n";
continue;
}
mod.GUID = sGuid;
mod.iYear = ReturnInt(lookUpEditYear.Text);
mod.代理商 = s代理商编码;
if (gridView1.GetRowCellDisplayText(i, gridColdtmStart).ToString().Trim() == "")
{
sErr = sErr + "行" + (i + 1).ToString() + "协议开始日期不能为空\n";
}
mod.dDate1 = Convert.ToDateTime(gridView1.GetRowCellDisplayText(i, gridColdtmStart));
if (gridView1.GetRowCellDisplayText(i, gridColdtmEnd).ToString().Trim() == "")
{
sErr = sErr + "行" + (i + 1).ToString() + "协议结束日期不能为空\n";
}
mod.dDate2 = Convert.ToDateTime(gridView1.GetRowCellDisplayText(i, gridColdtmEnd));
mod.返点方式 = s返点方式;
mod.品种 = s编码;
//mod.或有条款 = gridView1.GetRowCellDisplayText(i, gridCol或有条款).ToString().Trim();
if (gridView1.GetRowCellValue(i, gridCol底价).ToString().Trim() != "")
{
mod.底价 = ReturnDecimal(gridView1.GetRowCellValue(i, gridCol底价), 2);
}
if (gridView1.GetRowCellValue(i, gridCol协议销量).ToString().Trim() != "")
{
mod.协议销量 = ReturnDecimal(gridView1.GetRowCellValue(i, gridCol协议销量), 2);
}
if (gridView1.GetRowCellValue(i, gridCol保证金).ToString().Trim() != "")
{
mod.保证金 = ReturnDecimal(gridView1.GetRowCellValue(i, gridCol保证金), 2);
}
if (gridView1.GetRowCellValue(i, gridColM1).ToString().Trim() != "")
{
mod.M1 = ReturnDecimal(gridView1.GetRowCellValue(i, gridColM1), 2);
}
if (gridView1.GetRowCellValue(i, gridColM2).ToString().Trim() != "")
{
mod.M2 = ReturnDecimal(gridView1.GetRowCellValue(i, gridColM2), 2);
}
if (gridView1.GetRowCellValue(i, gridColM3).ToString().Trim() != "")
{
mod.M3 = ReturnDecimal(gridView1.GetRowCellValue(i, gridColM3), 2);
}
if (gridView1.GetRowCellValue(i, gridColM4).ToString().Trim() != "")
{
mod.M4 = ReturnDecimal(gridView1.GetRowCellValue(i, gridColM4), 2);
}
if (gridView1.GetRowCellValue(i, gridColM5).ToString().Trim() != "")
{
mod.M5 = ReturnDecimal(gridView1.GetRowCellValue(i, gridColM5), 2);
}
if (gridView1.GetRowCellValue(i, gridColM6).ToString().Trim() != "")
{
mod.M6 = ReturnDecimal(gridView1.GetRowCellValue(i, gridColM6), 2);
}
if (gridView1.GetRowCellValue(i, gridColM7).ToString().Trim() != "")
{
mod.M7 = ReturnDecimal(gridView1.GetRowCellValue(i, gridColM7), 2);
}
if (gridView1.GetRowCellValue(i, gridColM8).ToString().Trim() != "")
{
mod.M8 = ReturnDecimal(gridView1.GetRowCellValue(i, gridColM8), 2);
}
if (gridView1.GetRowCellValue(i, gridColM9).ToString().Trim() != "")
{
mod.M9 = ReturnDecimal(gridView1.GetRowCellValue(i, gridColM9), 2);
}
if (gridView1.GetRowCellValue(i, gridColM10).ToString().Trim() != "")
{
mod.M10 = ReturnDecimal(gridView1.GetRowCellValue(i, gridColM10), 2);
}
if (gridView1.GetRowCellValue(i, gridColM11).ToString().Trim() != "")
{
mod.M11 = ReturnDecimal(gridView1.GetRowCellValue(i, gridColM11), 2);
}
if (gridView1.GetRowCellValue(i, gridColM12).ToString().Trim() != "")
{
mod.M12 = ReturnDecimal(gridView1.GetRowCellValue(i, gridColM12), 2);
}
mod.CreateUid = sUid;
mod.CreateDate = DateTime.Now;
DAL.客户协议登记表 dal = new 基础设置.DAL.客户协议登记表();
sSQL = dal.Add(mod);
aList.Add(sSQL);
b = true;
}
sSQL = @"
delete 客户协议登记表_业务员 where GUID = 'aaaaaaaaaa'
";
sSQL = sSQL.Replace("aaaaaaaaaa", sGuid.ToString());
aList.Add(sSQL);
for (int i = 0; i < gridView2.RowCount; i++)
{
string s业务员 = gridView2.GetRowCellValue(i, gridCol业务员编码).ToString().Trim();
if (s业务员 == "")
{
continue;
}
Model.客户协议登记表_业务员 mod = new 基础设置.Model.客户协议登记表_业务员();
mod.cPersonCode = s业务员;
mod.Remark = gridView2.GetRowCellValue(i, gridCol备注).ToString().Trim();
if (gridView2.GetRowCellValue(i, gridCol开始日期).ToString().Trim() != "")
{
mod.StartDate = ReturnDateTime(gridView2.GetRowCellValue(i, gridCol开始日期));
}
if (gridView2.GetRowCellValue(i, gridCol结束日期).ToString().Trim() != "")
{
mod.ENDDate = ReturnDateTime(gridView2.GetRowCellValue(i, gridCol结束日期));
}
mod.GUID = sGuid;
DAL.客户协议登记表_业务员 dal = new 基础设置.DAL.客户协议登记表_业务员();
sSQL = dal.Add(mod);
aList.Add(sSQL);
}
if (!b)
{
throw new Exception("没有需要保存的数据");
}
if (sErr.Trim() != "")
{
throw new Exception(sErr);
}
if (aList.Count > 0)
{
clsSQLCommond.ExecSqlTran(aList);
MessageBox.Show("保存成功");
btnRefresh();
}
}
catch (Exception ee)
{
throw new Exception(ee.Message);
}
}
