/// <summary>
/// 增加一条数据
/// </summary>
public int Add(BaseMenu model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into BaseMenu(");
strSql.Append("Memo,SortId,Name,ModuleId,PMenuId");
strSql.Append(") values (");
strSql.Append("'" + model.Memo + "',");
strSql.Append(model.SortId + ",");
strSql.Append("'" + model.Name + "',");
strSql.Append(model.ModuleId + ",");
strSql.Append(model.PMenuId);
//strSql.Append("@Memo,@Image,@UrlId,@UrlName,@BindSQL,@WorkId,@SortId,@Name,@DllName,@FunName,@ModuleId,@PMenuId,@MenuToolBar,@MenuLookBar");
strSql.Append(") ");
object obj = dbc.ExeInfochange(strSql.ToString());
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
public int tb_WareHouseAdd(tb_WareHouse good)
{
int intFalg = 0;
try
{
string str_Add = "insert into tb_WareHouse(WareID,WareName,Remark) values( ";
str_Add += " '" + good.strWareID + "','" + good.strWareName + "','" + good.strRemark + "')";
string sql = "select Count(1) from tb_WareHouse where WareID='" + good.strWareID + "'";
//SqlCommand cmd1 = new SqlCommand(sql, conn);
int count = dbc.ExecuteSelect(sql);
if (count > 0)
{
MessageUtil.ShowError("仓库编号已存在!");
return(0);
}
else
{
intFalg = dbc.ExeInfochange(str_Add);
return(intFalg);
}
}
catch (Exception ee)
{
MessageBox.Show(ee.ToString());
return(intFalg);
}
}
//public bool Exists(int ModuleId)
//{
// StringBuilder strSql = new StringBuilder();
// strSql.Append("select count(1) from BaseModule");
// strSql.Append(" where ");
// strSql.Append(" ModuleId = @ModuleId ");
// SqlParameter[] parameters = {
// new SqlParameter("@ModuleId", SqlDbType.Int,4)
// };
// parameters[0].Value = ModuleId;
// return DbHelperSQL.Exists(strSql.ToString(), parameters);
//}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(BaseModule model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into BaseModule(");
strSql.Append("Name,Memo,SortId");
strSql.Append(") values (");
strSql.Append("@Name,@Memo,@SortId");
strSql.Append(") ");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@Name", SqlDbType.VarChar, 200),
new SqlParameter("@Memo", SqlDbType.VarChar, 254),
new SqlParameter("@SortId", SqlDbType.Int, 4)
};
parameters[0].Value = model.Name;
parameters[1].Value = model.Memo;
parameters[2].Value = model.SortId;
object obj = dbc.ExeInfochange(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
public int tb_EmpInfoAdd(tb_EmpInfo Empinfo)
{
int intFalg = 0;
try
{
string str_Add = "insert into tb_EmpInfo values( ";
str_Add += " '" + Empinfo.strEmpId + "','" + Empinfo.strEmpName + "',";
str_Add += " '" + Empinfo.strEmpLoginPwd + "',";
str_Add += " '" + Empinfo.strEmpDept + "','" + Empinfo.strEmpPost + "'," + " '" + Empinfo.strEmpPhone + "'," + Empinfo.intEmpFalg + ",1,null," + Empinfo.intEmpGroupID;
str_Add += ", '" + Empinfo.strEmpKilnNO + "','" + Empinfo.strEmpWorshoId + "')";
string sql = "select Count(1) from tb_EmpInfo where EmpId='" + Empinfo.strEmpId + "'";
//SqlCommand cmd1 = new SqlCommand(sql, conn);
int count = dbl.ExecuteSelect(sql);
if (count > 0)
{
MessageUtil.ShowError("该员工已存在!");
return(0);
}
else
{
intFalg = dbl.ExeInfochange(str_Add);
return(intFalg);
}
}
catch (Exception ee)
{
MessageBox.Show(ee.ToString());
return(intFalg);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(tb_settings model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_Settings set ");
strSql.Append(" id = @id , ");
strSql.Append(" PicSaveStyle = @PicSaveStyle , ");
strSql.Append(" PicPath = @PicPath ");
strSql.Append(" isNeedRate = @isNeedRate ");
strSql.Append(" where id=@id ");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4),
new SqlParameter("@PicSaveStyle", SqlDbType.Int, 4),
new SqlParameter("@PicPath", SqlDbType.VarChar, 2000),
new SqlParameter("@isNeedRate", SqlDbType.Int, 4)
};
parameters[0].Value = model.id;
parameters[1].Value = model.PicSaveStyle;
parameters[2].Value = model.PicPath;
parameters[3].Value = model.IsNeedRate;
int rows = dbl.ExeInfochange(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public int tb_ModelInfoAdd(
tb_ModelInfo good
)
{
int intFalg = 0;
try
{
string str_Add = @"INSERT INTO [dbo].[tb_ModelInfo]
([ModelNo]
,[ModelName]
,[FCreater]
,[FCreateDate]
,[FModifier]
,[FModifydate]
,[FImagePath]
,[FTypeSteps1]
,[FTypeSteps2]
,[FTypeSteps3]
,[FIsStop]
,FMaterialQty)
VALUES (";
str_Add += " '" + good.strModelNo + "','" + good.strModelName + "',";
str_Add += " '" + good.strFCreater + "',";
str_Add += " '" + good.dFCreateDate + "','" + good.strFModifier + "','" + good.dFModifydate + "','" + good.strFImagePath + "',";
str_Add += "'" + good.strFTypeSteps1 + "','" + good.strFTypeSteps2 + "','" + good.strFTypeSteps3 + "'," + good.iFIsStop + ",'" + good.strFMaterialQty + "')";
string sql = "select Count(1) from tb_ModelInfo where ModelNo='" + good.strModelNo + "'";
//SqlCommand cmd1 = new SqlCommand(sql, conn);
int count = dbc.ExecuteSelect(sql);
if (count > 0)
{
MessageUtil.ShowError("器型编号已存在!");
return(0);
}
else
{
intFalg = dbc.ExeInfochange(str_Add);
//}
return(intFalg);
}
}
catch (Exception ee)
{
MessageBox.Show(ee.ToString());
return(intFalg);
}
}
public int tb_WorkNumAdd(tb_WorkNum WorkNum)
{
int intFlag = 0;
try
{
string str_Add = "Insert tb_WorkNum Values('" + WorkNum.strWorkNumID + "','" + WorkNum.strWorkNumName + "','" + WorkNum.strremark + "')";
intFlag = dbl.ExeInfochange(str_Add);
conn.Dispose();
return(intFlag);
}
catch (Exception ee)
{
MessageBox.Show(ee.ToString());
return(intFlag);
}
}
public int tb_GoodsInfoAdd(
tb_GoodsInfo good
)
{
int intFalg = 0;
try
{
/* if (ishaspics)
* {
* string str_Add = "insert into tb_GoodsInfo(GoodId,GoodName,ItemNO,ModelNO,GoodMaterial,FCreater,FCreateDate,fImage) values( ";
* str_Add += " '" + good.strGoodsId + "','" + good.strGoodsName + "',";
* str_Add += " '" + good.strItemNO + "',";
* str_Add += " '" + good.strModelNO + "','" + good.strGoodMaterial + "','" + good.strFCreater + "','" + good.dFCreateDate + "',@img )";
* intFalg = dbc.ExeInfochange(str_Add, "@img", good.image);
* }
* else
* {
*/
string str_Add = "insert into tb_GoodsInfo(GoodId,GoodName,ItemNO,ModelNO,GoodMaterial,FCreater,FCreateDate,FImagePath) values( ";
str_Add += " '" + good.strGoodsId + "','" + good.strGoodsName + "',";
str_Add += " '" + good.strItemNO + "',";
str_Add += " '" + good.strModelNO + "','" + good.strGoodMaterial + "','" + good.strFCreater + "','" + good.dFCreateDate + "','" + good.strFImagePath + "')";;
//str_Add += " '" + good.strFColor + "','" + good.strFTypeSteps1 + "','" + good.strFTypeSteps2 + "','" + good.strFTypeSteps3 + "','" + good.strFColorSteps + "'," + good.iFIsStop+
string sql = "select Count(1) from tb_GoodsInfo where GoodId='" + good.strGoodsId + "'";
//SqlCommand cmd1 = new SqlCommand(sql, conn);
int count = dbc.ExecuteSelect(sql);
if (count > 0)
{
MessageUtil.ShowError("产品编号已存在!");
return(0);
}
else
{
intFalg = dbc.ExeInfochange(str_Add);
//}
return(intFalg);
}
}
catch (Exception ee)
{
MessageBox.Show(ee.ToString());
return(intFalg);
}
}
public int tb_BaseAdd(
tb_Base good
)
{
int intFalg = 0;
try
{
/* if (ishaspics)
* {
* string str_Add = "insert into tb_BaseInfo(GoodId,GoodName,ItemNO,ModelNO,GoodMaterial,FCreater,FCreateDate,fImage) values( ";
* str_Add += " '" + good.strGoodsId + "','" + good.strGoodsName + "',";
* str_Add += " '" + good.strItemNO + "',";
* str_Add += " '" + good.strModelNO + "','" + good.strGoodMaterial + "','" + good.strFCreater + "','" + good.dFCreateDate + "',@img )";
* intFalg = dbc.ExeInfochange(str_Add, "@img", good.image);
* }
* else
* {
*/
string str_Add = "insert into tb_Base(FClass,FBaseID,FBaseName,FRemark) values( ";
str_Add += " '" + good.strFClass + "','" + good.strFBaseID + "',";
str_Add += " '" + good.strFBaseName + "',";
str_Add += " '" + good.strFRemark + "')";
string sql = "select Count(1) from tb_Base where FBaseID='" + good.strFBaseID + "'";
//SqlCommand cmd1 = new SqlCommand(sql, conn);
int count = dbc.ExecuteSelect(sql);
if (count > 0)
{
MessageUtil.ShowError("编号已存在!");
return(0);
}
else
{
intFalg = dbc.ExeInfochange(str_Add);
//}
return(intFalg);
}
}
catch (Exception ee)
{
MessageBox.Show(ee.ToString());
return(intFalg);
}
}
public int tb_ColorInfoAdd(
tb_ColorInfo good
)
{
int intFalg = 0;
try
{
string str_Add = @"INSERT INTO [dbo].[tb_ColorInfo]
([ColorNo]
,[ColorName]
,[FCreater]
,[FCreateDate]
,[FModifier]
,[FModifydate]
,[FColorSteps]
,[FIsStop])
VALUES(";
str_Add += " '" + good.strColorNo + "','" + good.strColorName + "',";
str_Add += " '" + good.strFCreater + "',";
str_Add += " '" + good.dFCreateDate + "','" + good.strFModifier + "','" + good.dFModifydate + "',";
str_Add += "'" + good.strFColorSteps + "'," + good.iFIsStop + ")";
string sql = "select Count(1) from tb_ColorInfo where ColorNo='" + good.strColorNo + "'";
//SqlCommand cmd1 = new SqlCommand(sql, conn);
int count = dbc.ExecuteSelect(sql);
if (count > 0)
{
MessageUtil.ShowError("花色编号已存在!");
return(0);
}
else
{
intFalg = dbc.ExeInfochange(str_Add);
//}
return(intFalg);
}
}
catch (Exception ee)
{
MessageBox.Show(ee.ToString());
return(intFalg);
}
}
public int WareInOutADD(WareInOut FH)
{
int intFalg = 0;
try
{
string str_Add = "insert into WareInOut(FDate,FWorknum,FOperator,FWareID,FGoodID,FHGSL,FPSSL,FKLSL,FKHSL,FCarNO,FTYPE,FSerialNum,FGoodsName,FModelno,FItemID,FMaterial,FimagePath,FPSL,FInvoiceType) values( ";
str_Add += " '" + FH.dFDate + "','" + FH.strFWorknum + "',";
str_Add += " '" + FH.strFOperator + "','" + FH.strFWareID + "','" + FH.strFGoodsID + "',";
str_Add += FH.dFHGSL + "," + FH.dFPSSL + "," + FH.dFKLSL + "," + FH.dFKHSL + ",'" + FH.strFCarNO + "'," + FH.intFTYPE + ",'" + FH.strFSerialNum + "','" + FH.strFGoodsName + "','" + FH.strFModelno + "','" + FH.strFItemID + "','" + FH.strFMaterial + "','";
str_Add += FH.strFimagePath + "'," + FH.dFPSL + ",'" + FH.strFInvoiceType + "')";
intFalg = dbl.ExeInfochange(str_Add);
return(intFalg);
}
catch (Exception ee)
{
MessageBox.Show(ee.ToString());
return(intFalg);
}
}
public int tb_JCHADD(tb_JCH JCH)
{
int intFalg = 0;
try
{
string str_Add = "insert into tb_JCH(JCDate,JCWorknum,JCOperator,JCWareID,JCGoodsID,JCHGSL,JCPSSL,JCKLSL,JCKHSL,JCCarNO,JCTYPE,JCSerialNum,JCGoodsName,JCModelno,JCItemID,JCMaterial,FImagePath,FRYHGSL,FHGL,FZYID,FPSSL,FPSL,FKilnNo) values( ";
str_Add += " '" + JCH.dJCDate + "','" + JCH.strJCWorknum + "',";
str_Add += " '" + JCH.strJCOperator + "','" + JCH.strJCWareID + "','" + JCH.strJCGoodsID + "',";
str_Add += JCH.dJCHGSL + "," + JCH.dJCPSSL + "," + JCH.dJCKLSL + "," + JCH.dJCKHSL + ",'";
str_Add += JCH.strJCCarNO + "'," + JCH.intJCTYPE + ",'" + JCH.strJCSerialNum + "','" + JCH.strJCGoodsName + "','";
str_Add += JCH.strJCModelno + "','" + JCH.strJCItemID + "','" + JCH.strJCMaterial + "','" + JCH.strFImagePath + "'," + JCH.dFRYHGSL + "," + JCH.dFHGL + "," + JCH.iFZYID + "," + JCH.iFPSSL + "," + JCH.dFPSL + ",'" + JCH.strFKilnNo + "')";
intFalg = dbl.ExeInfochange(str_Add);
return(intFalg);
}
catch (Exception ee)
{
MessageBox.Show(ee.ToString());
return(intFalg);
}
}
}// end if
#endregion
static Boolean isGm(string _id)
{
Boolean result = false;
Dbconnection db = new Dbconnection();
string sql = "select empfalg from tb_empinfo where empid='" + _id + "'";
if (db.ExeInfochange(sql) != 0)
{
result = true;
}
return(result);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(int groupid, int moduleid, int menuid)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into BaseGroupMenu(");
strSql.Append("GroupId,ModuleId,MenuId");
strSql.Append(") values (");
strSql.Append(groupid + ",");
strSql.Append(moduleid + ",");
strSql.Append(menuid);
strSql.Append(") ");
object obj = dbc.ExeInfochange(strSql.ToString());
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
public int Add(
BaseGroup group
)
{
int intFalg = 0;
try
{
string str_Add = @"INSERT INTO [dbo].[BaseGroup]
([Name]
,[IsStop]
,[Admin]
,[Memo])
VALUES(";
str_Add += " '" + group.Name + "','" + group.IsStop + "',";
str_Add += " '" + group.Admin + "',";
str_Add += " '" + group.Memo + "')";
//string sql = "select Count(1) from tb_ColorInfo where ColorNo='" + group.strColorNo + "'";
//SqlCommand cmd1 = new SqlCommand(sql, conn);
//int count = dbc.ExecuteSelect(sql);
//if (count > 0)
//{
// MessageUtil.ShowError("花色编号已存在!");
// return 0;
// }
// else
//{
intFalg = dbc.ExeInfochange(str_Add);
//}
return(intFalg);
// }
}
catch (Exception ee)
{
//MessageBox.Show(ee.ToString());
return(intFalg);
}
}
public int SelPorcelainADD(tb_SelPorcelain sp)
{
int intFalg = 0;
try
{
string str_Add = @"INSERT INTO [dbo].[SelPorceLain] (
[PlApplyDate]
,[PlApplytime]
,[PLOperatorID]
,[PlOperator]
,[PlSerialNum]
,[PlWorkNumID]
,[PlGoodsID]
,[PlGoodsName]
,[PlKilnNo]
,[PlColor]
,[PlWorkshopId]
,[PlNeedGlazed]
,[PlModelFaults]
,[PlModelFaultsID ]
,[PlGlazeFaults]
,[PlFireFaults]
,[PlLevels]
,[FTypeSteps1]
,[FTypeSteps2]
,[FTypeSteps3]
,[FColorSteps]
,[PlQty]
,[PlThisQty]
,PlModelNo
,[FImagePath],
fMaterial)
VALUES ( ";
str_Add += "'" + sp.dPlApplyDate + "'," +
" '" + sp.strPlApplytime + "'," +
" '" + sp.strPlOperatorID + "'," +
" '" + sp.strPlOperator + "'," +
" '" + sp.strPlSerialNum + "'," +
" '" + sp.strPlWorkNumID + "'," +
" '" + sp.strPlGoodsID + "'," +
" '" + sp.strPlGoodsName + "'," +
" '" + sp.strPlKilnNo + "'," +
" '" + sp.strPlColor + "'," +
" '" + sp.strPlWorkshopId + "'," +
" " + sp.iPlNeedGlazed + "," +
" '" + sp.strPlModelFaults + "'," +
" '" + sp.strPlModelFaultsID + "'," +
" '" + sp.strPlGlazeFaults + "'," +
" '" + sp.strPlFireFaults + "'," +
" '" + sp.strPlLevels + "'," +
" '" + sp.strFTypeSteps1 + "'," +
" '" + sp.strFTypeSteps2 + "'," +
" '" + sp.strFTypeSteps3 + "'," +
" '" + sp.strFColorSteps + "'," +
" " + sp.iPlQty + "," +
"" + sp.iPlThisQty + "," +
" '" + sp.strPlModelNo + "'," +
"'" + sp.strFImagePath + "'," +
"'" + sp.FMaterial + "')";
intFalg = dbl.ExeInfochange(str_Add);
return(intFalg);
}
catch (Exception ee)
{
MessageBox.Show(ee.ToString());
return(intFalg);
}
}
