?? dataoperate.cs
字號:
sqlcom.Parameters.Add("@HandlePeople", SqlDbType.VarChar, 20).Value = P_str_HPeople;
sqlcom.Parameters.Add("@ISRemark", SqlDbType.VarChar, 1000).Value = P_str_Remark;
SqlParameter returnValue = sqlcom.Parameters.Add("returnValue", SqlDbType.Int, 4);
returnValue.Direction = ParameterDirection.ReturnValue;
sqlcon.Open();
try
{
sqlcom.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
sqlcom.Dispose();
sqlcon.Close();
sqlcon.Dispose();
}
int P_int_returnValue = (int)returnValue.Value;
return P_int_returnValue;
}
#endregion
#region 添加供應商信息
/// <summary>
/// 添加供應商信息
/// </summary>
/// <param name="P_str_PrName">供應商名稱</param>
/// <param name="P_str_PrPeople">負責人</param>
/// <param name="P_str_PrPhone">供應商聯系電話</param>
/// <param name="P_str_PrFax">供應商傳真號碼</param>
/// <param name="P_int_PrRemark">備注</param>
/// <returns>返回一個int類型的值</returns>
public int InsertProvider(string P_str_PrName, string P_str_PrPeople, string P_str_PrPhone, string P_str_PrFax, string P_int_PrRemark)
{
SqlConnection sqlcon = datacon.getcon();
SqlCommand sqlcom = new SqlCommand("proc_insertProvider", sqlcon);
sqlcom.CommandType = CommandType.StoredProcedure;
sqlcom.Parameters.Add("@PrName", SqlDbType.VarChar, 100).Value = P_str_PrName;
sqlcom.Parameters.Add("@PrPeople", SqlDbType.VarChar, 20).Value = P_str_PrPeople;
sqlcom.Parameters.Add("@PrPhone", SqlDbType.VarChar, 20).Value = P_str_PrPhone;
sqlcom.Parameters.Add("@PrFax", SqlDbType.VarChar, 20).Value = P_str_PrFax;
sqlcom.Parameters.Add("@PrRemark", SqlDbType.VarChar, 1000).Value = P_int_PrRemark;
SqlParameter returnValue = sqlcom.Parameters.Add("returnValue", SqlDbType.Int, 4);
returnValue.Direction = ParameterDirection.ReturnValue;
sqlcon.Open();
try
{
sqlcom.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
sqlcom.Dispose();
sqlcon.Close();
sqlcon.Dispose();
}
int P_int_returnValue = (int)returnValue.Value;
return P_int_returnValue;
}
#endregion
#region 添加倉庫信息
/// <summary>
/// 添加倉庫信息
/// </summary>
/// <param name="P_str_StoreName">倉庫名稱</param>
/// <param name="P_str_StorePeople">倉庫負責人</param>
/// <param name="P_str_StorePhone">倉庫電話</param>
/// <param name="P_str_StoreUnit">倉庫所屬單位</param>
/// <param name="P_int_StoreRemark">備注</param>
/// <returns>返回一個int類型的值</returns>
public int InsertStorage(string P_str_StoreName, string P_str_StorePeople, string P_str_StorePhone, string P_str_StoreUnit, string P_int_StoreRemark)
{
SqlConnection sqlcon = datacon.getcon();
SqlCommand sqlcom = new SqlCommand("proc_insertStorage", sqlcon);
sqlcom.CommandType = CommandType.StoredProcedure;
sqlcom.Parameters.Add("@StoreName", SqlDbType.VarChar, 100).Value = P_str_StoreName;
sqlcom.Parameters.Add("@StorePeople", SqlDbType.VarChar, 20).Value = P_str_StorePeople;
sqlcom.Parameters.Add("@StorePhone", SqlDbType.VarChar, 20).Value = P_str_StorePhone;
sqlcom.Parameters.Add("@StoreUnit", SqlDbType.VarChar, 100).Value = P_str_StoreUnit;
sqlcom.Parameters.Add("@StoreRemark", SqlDbType.VarChar, 1000).Value = P_int_StoreRemark;
SqlParameter returnValue = sqlcom.Parameters.Add("returnValue", SqlDbType.Int, 4);
returnValue.Direction = ParameterDirection.ReturnValue;
sqlcon.Open();
try
{
sqlcom.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
sqlcom.Dispose();
sqlcon.Close();
sqlcon.Dispose();
}
int P_int_returnValue = (int)returnValue.Value;
return P_int_returnValue;
}
#endregion
#region 添加新用戶
/// <summary>
/// 添加新用戶
/// </summary>
/// <param name="P_str_UserName">用戶名</param>
/// <param name="P_str_UserPwd">用戶密碼</param>
/// <param name="P_str_UserRight">用戶權限</param>
/// <returns>返回一個int類型的值</returns>
public int InsertUser(string P_str_UserName, string P_str_UserPwd, string P_str_UserRight)
{
SqlConnection sqlcon = datacon.getcon();
SqlCommand sqlcom = new SqlCommand("proc_insertUser",sqlcon);
sqlcom.CommandType = CommandType.StoredProcedure;
sqlcom.Parameters.Add("@UserName", SqlDbType.VarChar, 20).Value = P_str_UserName;
sqlcom.Parameters.Add("@UserPwd", SqlDbType.VarChar, 20).Value = P_str_UserPwd;
sqlcom.Parameters.Add("@UserRight", SqlDbType.Char, 10).Value = P_str_UserRight;
SqlParameter returnValue = sqlcom.Parameters.Add("returnValue", SqlDbType.Int, 4);
returnValue.Direction = ParameterDirection.ReturnValue;
sqlcon.Open();
try
{
sqlcom.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
sqlcom.Dispose();
sqlcon.Close();
sqlcon.Dispose();
}
int P_int_returnValue = (int)returnValue.Value;
return P_int_returnValue;
}
#endregion
#region 盤點貨物
/// <summary>
/// 盤點貨物
/// </summary>
/// <param name="P_int_ISID">貨物入庫編號</param>
/// <param name="P_str_SName">倉庫名稱</param>
/// <param name="P_str_GName">貨物名稱</param>
/// <param name="P_str_GUnit">計量單位</param>
/// <param name="P_int_CKNum">盤點數量</param>
/// <param name="P_int_PALNum">盈虧數量</param>
/// <param name="P_str_CPeople">盤點人</param>
/// <param name="P_str_Remark">備注</param>
/// <returns>返回一個int類型的值</returns>
public int InsertCheck(int P_int_GoodsID, string P_str_SName, string P_str_GName,
string P_str_GUnit, int P_int_CKNum, int P_int_PALNum, string P_str_CPeople, string P_str_Remark)
{
SqlConnection sqlcon = datacon.getcon();
SqlCommand sqlcom = new SqlCommand("proc_insertCheck", sqlcon);
sqlcom.CommandType = CommandType.StoredProcedure;
sqlcom.Parameters.Add("@GoodsID", SqlDbType.BigInt).Value = P_int_GoodsID;
sqlcom.Parameters.Add("@StoreName", SqlDbType.VarChar, 100).Value = P_str_SName;
sqlcom.Parameters.Add("@GoodsName", SqlDbType.VarChar, 50).Value = P_str_GName;
sqlcom.Parameters.Add("@GoodsUnit", SqlDbType.Char, 8).Value = P_str_GUnit;
sqlcom.Parameters.Add("@CheckNum", SqlDbType.BigInt).Value = P_int_CKNum;
sqlcom.Parameters.Add("@PALNum", SqlDbType.BigInt).Value = P_int_PALNum;
sqlcom.Parameters.Add("@CheckPeople", SqlDbType.VarChar, 20).Value = P_str_CPeople;
sqlcom.Parameters.Add("@CheckRemark", SqlDbType.VarChar, 1000).Value = P_str_Remark;
SqlParameter returnValue = sqlcom.Parameters.Add("returnValue", SqlDbType.Int, 4);
returnValue.Direction = ParameterDirection.ReturnValue;
sqlcon.Open();
try
{
sqlcom.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
sqlcom.Dispose();
sqlcon.Close();
sqlcon.Dispose();
}
int P_int_returnValue = (int)returnValue.Value;
return P_int_returnValue;
}
#endregion
#region 修改用戶信息
/// <summary>
/// 修改用戶信息
/// </summary>
/// <param name="P_int_UID">用戶編號</param>
/// <param name="P_str_UserPwd">用戶密碼</param>
/// <param name="P_str_UserRight">用戶權限</param>
/// <returns>返回一個int類型的值</returns>
public void updateUser(int P_int_UID,string P_str_UserPwd, string P_str_UserRight)
{
SqlConnection sqlcon = datacon.getcon();
SqlCommand sqlcom = new SqlCommand("proc_updateUser", sqlcon);
sqlcom.CommandType = CommandType.StoredProcedure;
sqlcom.Parameters.Add("@UserID", SqlDbType.BigInt).Value = P_int_UID;
sqlcom.Parameters.Add("@UserPwd", SqlDbType.VarChar, 20).Value = P_str_UserPwd;
sqlcom.Parameters.Add("@UserRight", SqlDbType.Char, 10).Value = P_str_UserRight;
sqlcon.Open();
try
{
sqlcom.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
sqlcom.Dispose();
sqlcon.Close();
sqlcon.Dispose();
}
}
#endregion
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -