/// <summary>
/// 获取项名称集合
/// </summary>
/// <param name="AVR_IDENT_TYPE"></param>
/// <param name="AVR_PROTOCOL_NO"></param>
/// <returns></returns>
public List <CLDC_DataCore.Model.PROTOCOLModel.PROTOCOLinfo> GetAVR_ITEM_NAMEList(int AVR_IDENT_TYPE, int AVR_PROTOCOL_NO)
{
try
{
CLDC_DataCore.DataBase.DbHelperOleDb.connectionString = strPath;
List <CLDC_DataCore.Model.PROTOCOLModel.PROTOCOLinfo> list = new List <CLDC_DataCore.Model.PROTOCOLModel.PROTOCOLinfo>();
string sql = "select AVR_ITEM_NAME from PROTOCOL_DLT645DICT where AVR_PROTOCOL_NO = '" + AVR_PROTOCOL_NO + "' and AVR_IDENT_TYPE = '" + AVR_IDENT_TYPE + "'";
OleDbDataReader dr = CLDC_DataCore.DataBase.DbHelperOleDb.ExecuteReader(sql);
if (dr.HasRows)
{
while (dr.Read())
{
CLDC_DataCore.Model.PROTOCOLModel.PROTOCOLinfo proinfo = new CLDC_DataCore.Model.PROTOCOLModel.PROTOCOLinfo();
proinfo.AVR_ITEM_NAME = dr["AVR_ITEM_NAME"].ToString();
list.Add(proinfo);
}
dr.Close();
}
return(list);
}
catch { return(null); }
}
/// <summary>
/// 获取规约信息
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
public List <CLDC_DataCore.Model.PROTOCOLModel.PROTOCOLinfo> GetPROTOCOLinfoList(string sql)
{
try
{
CLDC_DataCore.DataBase.DbHelperOleDb.connectionString = strPath;
List <CLDC_DataCore.Model.PROTOCOLModel.PROTOCOLinfo> list = new List <CLDC_DataCore.Model.PROTOCOLModel.PROTOCOLinfo>();
OleDbDataReader dr = CLDC_DataCore.DataBase.DbHelperOleDb.ExecuteReader(sql);
if (dr.HasRows)
{
while (dr.Read())
{
CLDC_DataCore.Model.PROTOCOLModel.PROTOCOLinfo proinfo = new CLDC_DataCore.Model.PROTOCOLModel.PROTOCOLinfo();
proinfo.PK_LNG_DLT_ID = int.Parse(dr["PK_LNG_DLT_ID"].ToString());
proinfo.AVR_PROTOCOL_NO = dr["AVR_PROTOCOL_NO"].ToString();
proinfo.AVR_IDENT_TYPE = dr["AVR_IDENT_TYPE"].ToString();
proinfo.AVR_ITEM_NAME = dr["AVR_ITEM_NAME"].ToString();
proinfo.AVR_ID = dr["AVR_ID"].ToString();
proinfo.CHR_CLASS = dr["CHR_CLASS"].ToString();
proinfo.LNG_LENGTH = dr["LNG_LENGTH"].ToString();
proinfo.LNG_DOT = dr["LNG_DOT"].ToString();
proinfo.CHR_TYPE = dr["CHR_TYPE"].ToString();
proinfo.AVR_FORMAT = dr["AVR_FORMAT"].ToString();
proinfo.AVR_DEF_VALUE = dr["AVR_DEF_VALUE"].ToString();
list.Add(proinfo);
}
dr.Close();
}
return(list);
}
catch { return(null); }
}
/// <summary>
/// 根据编码类型（编码类型的描述）和协议名称得到编码号
/// </summary>
/// <param name="AVR_IDENT_TYPE"></param>
/// <param name="AVR_PROTOCOL_NAME"></param>
/// <returns></returns>
public string GetAVR_IDENT_TYPE(string DESCRIPTION, string AVR_PROTOCOL_NAME)
{
string GetTypr = "";
string sql = string.Format("select * from PROTOCOL_TYPE where AVR_PROTOCOL_NAME = '{0}' and DESCRIPTION = '{1}'", AVR_PROTOCOL_NAME, DESCRIPTION);
CLDC_DataCore.DataBase.DbHelperOleDb.connectionString = strPath;
OleDbDataReader dr = CLDC_DataCore.DataBase.DbHelperOleDb.ExecuteReader(sql);
if (dr.HasRows)
{
while (dr.Read())
{
CLDC_DataCore.Model.PROTOCOLModel.PROTOCOLinfo proinfo = new CLDC_DataCore.Model.PROTOCOLModel.PROTOCOLinfo();
GetTypr = dr["AVR_IDENT_TYPE"].ToString();
}
dr.Close();
}
return(GetTypr);
}
private void btn_Save_Click(object sender, EventArgs e)
{
for (int i = 0; i < Dgv_Data.Rows.Count; i++)
{
for (int j = 1; j < 8; j++)
{
if (Dgv_Data.Rows[i].Cells[j].Value == null)
{
MessageBox.Show(this, "请填满数据后再保存", "提示");
return;
}
}
}
ArrayList strList = new ArrayList();
for (int i = 0; i < Dgv_Data.Rows.Count; i++)
{
string sql = "";
CLDC_DataCore.Model.PROTOCOLModel.PROTOCOLinfo protocolinfo = new CLDC_DataCore.Model.PROTOCOLModel.PROTOCOLinfo();
protocolinfo.AVR_PROTOCOL_NO = GetAVR_PROTOCOL_NO(Dgv_Data.Rows[i].Cells[1].Value.ToString());
protocolinfo.AVR_IDENT_TYPE = GetAVR_IDENT_TYPE(Dgv_Data.Rows[i].Cells[2].Value.ToString());
protocolinfo.AVR_ITEM_NAME = Dgv_Data.Rows[i].Cells[3].Value.ToString();
protocolinfo.AVR_ID = Dgv_Data.Rows[i].Cells[4].Value.ToString();
protocolinfo.CHR_CLASS = GetCodeByTYPE(Dgv_Data.Rows[i].Cells[5].Value.ToString());
protocolinfo.LNG_LENGTH = Dgv_Data.Rows[i].Cells[6].Value.ToString();
protocolinfo.LNG_DOT = Dgv_Data.Rows[i].Cells[7].Value.ToString();
protocolinfo.CHR_TYPE = GetCodeByTYPE(Dgv_Data.Rows[i].Cells[8].Value.ToString());
protocolinfo.AVR_FORMAT = Dgv_Data.Rows[i].Cells[9].Value == null ? "" : Dgv_Data.Rows[i].Cells[9].Value.ToString();
protocolinfo.AVR_DEF_VALUE = Dgv_Data.Rows[i].Cells[10].Value == null ? "" : Dgv_Data.Rows[i].Cells[10].Value.ToString();
if (Dgv_Data.Rows[i].Cells[0].Value == null)
{
protocolinfo.PK_LNG_DLT_ID = int.Parse(System.DateTime.Now.ToString("hhmmssff")) + i;
sql = string.Format(@"insert into PROTOCOL_DLT645DICT(PK_LNG_DLT_ID,AVR_PROTOCOL_NO,AVR_IDENT_TYPE,AVR_ITEM_NAME," +
"AVR_ID,CHR_CLASS,LNG_LENGTH,LNG_DOT,CHR_TYPE,AVR_FORMAT,AVR_DEF_VALUE) values (" +
"{0},'{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}')", +
protocolinfo.PK_LNG_DLT_ID,
protocolinfo.AVR_PROTOCOL_NO,
protocolinfo.AVR_IDENT_TYPE,
protocolinfo.AVR_ITEM_NAME,
protocolinfo.AVR_ID,
protocolinfo.CHR_CLASS,
protocolinfo.LNG_LENGTH,
protocolinfo.LNG_DOT,
protocolinfo.CHR_TYPE,
protocolinfo.AVR_FORMAT,
protocolinfo.AVR_DEF_VALUE,
protocolinfo.PK_LNG_DLT_ID);
}
else
{
protocolinfo.PK_LNG_DLT_ID = int.Parse(Dgv_Data.Rows[i].Cells[0].Value.ToString());
sql = string.Format(@"update PROTOCOL_DLT645DICT set AVR_PROTOCOL_NO ='{0}',AVR_IDENT_TYPE='{1}'," +
"AVR_ITEM_NAME='{2}',AVR_ID='{3}',CHR_CLASS='{4}',LNG_LENGTH='{5}'," +
"LNG_DOT='{6}',CHR_TYPE='{7}',AVR_FORMAT='{8}',AVR_DEF_VALUE='{9}' where PK_LNG_DLT_ID={10}",
protocolinfo.AVR_PROTOCOL_NO,
protocolinfo.AVR_IDENT_TYPE,
protocolinfo.AVR_ITEM_NAME,
protocolinfo.AVR_ID,
protocolinfo.CHR_CLASS,
protocolinfo.LNG_LENGTH,
protocolinfo.LNG_DOT,
protocolinfo.CHR_TYPE,
protocolinfo.AVR_FORMAT,
protocolinfo.AVR_DEF_VALUE,
protocolinfo.PK_LNG_DLT_ID);
}
strList.Add(sql);
}
bool blnSuccess = CLDC_DataCore.DataBase.DbHelperOleDb.ExecuteSqlTran(strList);
if (blnSuccess)
{
MessageBox.Show(this, "保存成功", "提示");
DGV_source();
show_TV_Protocol();
}
else
{
MessageBox.Show(this, "保存失败", "提示");
}
}